How to get DB2 9.7 cursor value in for loop where returned value is a string

How to get DB2 9.7 cursor value in for loop where returned value is a string

References

Reference NO 1

http://stackoverflow.com/questions/15198577/how-to-get-db2-9-7-cursor-value-in-for-loop-where-returned-value-is-a-string

Reference NO 2

http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/db2z_sqlstatevalues.htm

Reference NO 3

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000897.html

Reference NO 4

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000973.html

Reference NO 5

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000975.html

Reference NO 6

http://en.wikipedia.org/wiki/DB2_SQL_return_codes

Reference NO 7

#EANF#

Reference NO 8

#EANF#