Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    9

    Unanswered: need sample Cobol program for Store Procedure

    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

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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
    Last edited by dr_te_z; 04-22-10 at 10:33. Reason: more links

  3. #3
    Join Date
    Nov 2009
    Posts
    9
    Thanks a lot .very helpful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •