Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Filling Sqlda In Cobol Ii/ Os390 / Db2 V7.0

    Hi everybody,

    Today I got a big problem: my query needed a varying-list select statement what requires the use of COBOL pointers.
    I've got all the problems in the include (I'm following the steps of the IBM redbook "Squeezing the most out of Dynamic SQL").
    First problem: it says that all the variables inside SQLDA are not defined (so EXEC SQL INCLUDE SQLDA is not working as expected).
    A part from that I have other problems.
    To try solve all of them at a time, would anybody have a working example to show me?

    Thanks a lot.

  2. #2
    Join Date
    Mar 2004
    Posts
    2

    Re: Filling Sqlda In Cobol Ii/ Os390 / Db2 V7.0

    Hi everybody,

    I got my program working up to the first fetch. When I use expediter this is the information I get:

    ----------------- XPEDITER/CICS - ASSEMBLER BREAK/ABEND (2.20) ------------ECB3
    COMMAND ===> SCROLL ===> CSR
    PROGRAM: DFHD2EX1 MODULE: DFHD2EX1
    CAUSE: CICS-DB2 SUBTASK TRAN ABENDED ABEND CODE: AD2R
    INTERRUPT OFFSET: ...... ADDRESS: 80000000 PSW: 078D0000 00000000 00000000
    RESUME OFFSET: ...... ADDRESS: 80000000 LAST CICS MACRO/EXEC:

    INSTRUCTION:
    REGISTERS:

    R0 R1 R2 R3 R4 R5 R6 R7
    F2000CC8 259F9714 257AF210 00000000 259F9AAA 00058680 244D3B40 257AF200

    R8 R9 R10 R11 R12 R13 R14 R15
    0008303C A59F96DE A59F554A 244D41D8 00058680 8004EA20 A59F565A 259F5544

    Could anybody give a hand?

    Thanks.

Posting Permissions

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