need sample Cobol program for Store Procedure

Navid2000 · #1 (**permalink**) 04-22-10, 04:43

hi

I need a sample cobol program to call a DB2 store procedure and write the returned result set to a data set or anywhere.

tnx,
Navid

dr_te_z · #2 (**permalink**) 04-22-10, 09:27

IBM Information Management Software for z/OS Solutions Information Center
http://groups.google.com/group/comp....da4deff6d029bd

The trick is not to check for SQLCODE = ZERO. In this case it is not what you want. Check for sqlcode +466 and do the complicated SQL ASSOSIATE thingies.

P.S. I already asked for a less complex structure https://www.ibm.com/developerworks/f...0461&#14000461

Navid2000 · #3 (**permalink**) 04-24-10, 01:32

Thanks a lot .very helpful.