|
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 |
|
|
|
|
