Fetch 1000 records in a cursor

[a***@fiserv.com]

Hi experts,

I have a join query in cursor contaning large amount of data.
I want to process in the batch of 1000 using a cursor.

I have already written a normal cursor which is giving me the error as

A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL0304N A value cannot be assigned to a host variable because the value is not within the range of the host variable's data type. SQLSTATE=22003

DECLARE C1
FETCH
INTO
<VARNAME>
CLOSE C1

Please let me know how to handle this issue.

Thanks in Advance


Ajay M

[Ian]

Post by a***@fiserv.com
Hi experts,
I have a join query in cursor contaning large amount of data.
I want to process in the batch of 1000 using a cursor.
I have already written a normal cursor which is giving me the error as
A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL0304N A value cannot be assigned to a host variable because the value is not within the range of the host variable's data type. SQLSTATE=22003
DECLARE C1
FETCH
INTO
<VARNAME>
CLOSE C1
Please let me know how to handle this issue.

Make sure that the variable <VARNAME> has a type that's consistent with
what your cursor is returning.