DB2 Pass-Through query question

[krymat]

I need to extract the last 90 days worth of data from a DB2 database. I have ODBC drivers setup already and I can link in and get the data with a select query but it takes a long time. I was hoping a Pass-Through query would speed it up, but I'm having problems with the SQL. I can get the following to work:

Select * from #ISCPIP.KPOD_T where CHNG_LOG_DATE_1 = '10/28/2001'

How would I get the Last 90 days worth?

 

[JoeMiller]

I believe there is a DB2 forum here, you might want to check there as there is most likely SMALL differences between Access SQL and DB2 SQL that will make a BIG difference!

HTH Joe Miller
joe.miller@flotech.net

 

[krymat]

I have reposted this question in the DB2 Forum
thread178-165592