View previous topic :: View next topic
|
Author |
Message |
sm_2009
New User
Joined: 10 May 2009 Posts: 72 Location: bangalore
|
|
|
|
hi all
i need to write a query using cursor
in table there is a date date_input
i need to declare cursor, with filering criteria as where year(date_input) = year(ws-input-date)
ws-input-date is ws variable of input date in file, it is also in db2 format.
pls suggest how can i write this query. |
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
Can you let us know what is the declaration of ws-input-date in cobol program |
|
Back to top |
|
|
sm_2009
New User
Joined: 10 May 2009 Posts: 72 Location: bangalore
|
|
|
|
hey got it
we can use as
where YEAR(DATE_INPUT) = YEAR('WS-INPUT-DATE') |
|
Back to top |
|
|
|