Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

function to subtract 200 days from date

I need to write the filter condition in cognos as follows:YRMOSDOS between (&YRMOSDOS - 200) AND (&YRMOSDOS)where YRMOSDOS is in date form. How do I achieve it?The database is in db2. Decimal function does not work.Please help. Thanks a lot.

View Answer   |  Jun 24 2005   11:20 AM GMT   |  asked by meenac
Database Management Systems, DB2, Data warehousing/Business intelligence


Monitor Internet Bandwidth

Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured.1. I want to monitor the internet usage by the users.2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User.Thanks for u'r reply in advance.

View Answer   |  Nov 29 2004   1:55 AM GMT   |  asked by GiriPrasad
DataCenter, Data center operations, E-business


DB2/400 SQL Sub Query Performance?

Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database.1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD ...

View Answer   |  Oct 20 2004   8:40 AM GMT   |  asked by apothen
Database Management Systems, DB2, Data warehousing/Business intelligence


Oracle In Linux

How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

View Answer   |  Oct 9 2004   1:41 AM GMT   |  asked by samachar
Implementation, Operating system platforms, Servers


1 - 4 of 4
<<PREVIOUS 1 NEXT>>