SQL FETCH RELATIVE

["Aaron Bartell" <albartell@xxxxxxxxx>]

Apparently high level tooling like Hibernate are taking their toll on my
ability to write an SQL statement from scratch.  Here's my issue - If I want
to use STRSQL to FETCH a relative set of records, I thought I could do the
following:

 

DECLARE C1 CURSOR FOR SELECT * FROM qiws/qcustcdt FETCH RELATIVE 2 FROM C1
FOR 6 ROWS

 

The above produces the following error: "Keyword FROM not expected. Valid
tokens: ROW ROWS."

 

DECLARE CURSOR syntax:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/r
bafzmsth2clcu.htm

 

SELECT syntax:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/r
bafzmstfets.htm

 

FETCH syntax:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/r
bafzmstfets.htm

 

Thanks,

Aaron Bartell

http://mowyourlawn.com