Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
abhilashapandey

New User


Joined: 22 Nov 2006
Posts: 12
Location: Delhi

PostPosted: Fri May 18, 2007 5:27 pm    Post subject: abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3
Reply with quote

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.
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri May 18, 2007 7:12 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Mon Jun 04, 2007 4:37 pm    Post subject: Re: abend AEY9 at "CALL 'DSNHLI' USING SQL-PLIST3
Reply with quote

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
Back to top
View user's profile Send private message
anv2005

New User


Joined: 14 Jul 2005
Posts: 44
Location: US

PostPosted: Mon Jun 04, 2007 10:11 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us