|
View previous topic :: View next topic
|
| Author |
Message |
chandan.inst
Active User
Joined: 03 Nov 2005
Posts: 275
Location: Mumbai
|
|
|
|
Hi All,
I am trying to Select data for 6 days from a DB2 Table in a Cobol program
WHERE clause I am providing is as below
| Code: |
| WHERE DATE_COLUMN BETWEEN (:WS-INPUT-DATE - 6 DAYS) AND :WS-INPUT-DATE |
But this is giving sql error code as -401
This query works fine in SPUFI
Here WS-INPUT-DATE coming from Input file
I tried like below as well
| Code: |
| WHERE DATE_COLUMN BETWEEN DATE (DAYS(:WS-INPUT-DATE) - 6 DAYS) AND :WS-INPUT-DATE |
But still no luck..
If I calculate WS-INPUT-DATE - 6 days outside sql query and provide it as Host variable it works fine.
I am just looking for if I am missing something and it's possible in Db2 query itself
Thanks in advance
Regards,
Chandan |
|
| Back to top |
|
 |
chandan.inst
Active User
Joined: 03 Nov 2005
Posts: 275
Location: Mumbai
|
|
|
|
Hi Guys,
My bad I got the soulution for this
I changed it as below
| Code: |
| WHERE DATE_COLUMN BETWEEN DATE (DAYS(:WS-INPUT-DATE) - 6 ) AND :WS-INPUT-DATE |
I should have used 6 instead of 6 days
Regards,
Chandan |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for posting the resolution 
d |
|
| Back to top |
|
|
|
|
