RE: SQL query

Wrong list for this question...I have posted some information regarding
this on the iseriesnetwork forums where you posted the same question... 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Shailendra_SKumar
Sent: Wednesday, August 16, 2006 10:56 AM
To: RPG programming on the AS400 / iSeries
Subject: SQL query 

Hi all 

I need your help, I am not too much expert in SQL, Actually I have to
figure it out one sql query for DB2 data base in AS400 system. 

ODCDAT and ODUDAT are the date fields (MDY format). Sql query should
like that 

Select * from filename where (Current date - ODCDAT) > 2 months and
(Current date - ODUDAT) > 2 months or ODUDAT = blanks) 


your help would be appreciated. 

Thank you in advance.




 

Regards,

Shailendra Kumar

_______________________________________

Software Engineer, GE-GDC ,STC . Hyderabad. 

Ph:040-30633871(Dir) // Mob: 98664-31670

 

 



DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.