abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3

abhilashapandey · New User Joined: 22 Nov 2006 Posts: 12 Location: Delhi

Hi,

I am coding an DB2 CICS program and when I tried to open a cursor, it gave me an abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3 ".

*****EXEC SQL
***** OPEN TRANS-LIST
*****END-EXEC
PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
CALL 'DSNHLI' USING SQL-PLIST3
==> CICS abend intercepted. Abend code = AEY9. after an external CALL.
==>
==> Press PF1 for a detailed description.
==>

Please let me know how to remove this.

William Thompson · Posted: Fri May 18, 2007 7:12 pm

Is DB2 installed/active in that CICS?

AEY9
Explanation: One of the following:
An EXEC CICS command has been issued that is not supported by the EXEC interface program DFHEIP.
A transaction has issued an EXEC CICS command which is supported in principle by the EXEC interface program DFHEIP, but for which the prerequisite function has not been included in the current CICS start-up.
A non-CICS command has been issued via an application "stub" (expansion of a DFHRMCAL macro), and the program DFHERM has detected that the necessary non-CICS support is not available.
An attempt has been made to use remote resources, but the local SYSID has been specified in an EXEC CICS command, or vice versa.
An attempt has been made to use remote resources, but ISC is not supported.
An EXEC CICS command contains an invalid AID or CONDITION identifier. This indicates that the EXEC CICS command has become corrupted.

skkp2006 · Posted: Mon Jun 04, 2007 4:37 pm

Go for step by step execution..Check whether the can is sucessfull or not...What do u do after the call??? Is the program displaying the data after the call??

Regards,
Syam

anv2005 · New User Joined: 14 Jul 2005 Posts: 44 Location: US

It probably indicates a link edit error.

Make sure your program module picks up CICS version of DSNHLI stub, i.e. module named DSNCLI from within CICS library SDFHLOAD, during MVS BINDER step, i.e. MVS LINK EDIT.

Alex.