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
