santsark
New User
Joined: 08 Aug 2008 Posts: 9 Location: Kolkata
|
|
|
|
We have defined a rowset cursor and trying to fetch the rowset cursor, but facing issue in pre-compile.
Code:
Declaration:
DECLARE CURSOR3 CURSOR
WITH ROWSET POSITIONING
FOR
SELECT a, b, c, d
FROM TableA
WHERE Z = 'MKT'
AND STAT = 'ACTIVE'
AND T_EFF_X ¬> :WS-CURRENT-TS
AND (T_END_X ¬< :WS-CURRENT-TS
OR T_END_X IS NULL)
END-EXEC.
Fetch:
EXEC SQL
FETCH ROWSET FROM CURSOR3
FOR 1000 ROWS
INTO :WS1-A ,
:WS1-B ,
:WS1-C ,
:WS1-D
END-EXEC
Error:
DB2 SQL PRECOMPILER MESSAGES
DSNH104I E DSNHSM3 LINE 8320 COL 33 ILLEGAL SYMBOL "FROM". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: STARTING
DSNH104I E DSNHSM3 LINE 8320 COL 38 ILLEGAL SYMBOL "CURSOR3".SOME SYMBOLS THAT MIGHT BE LEGAL ARE: AT
Please let me know if you know what the issue may be. I don't want to make this a scrollable cursor. I just want to do multi-fetch. |
|