Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need AIBRETRN value for end of IMS-DB in AERTDLI call.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
maheshurstd

New User


Joined: 16 Feb 2006
Posts: 14

PostPosted: Tue Nov 13, 2007 3:49 am    Post subject: Need AIBRETRN value for end of IMS-DB in AERTDLI call.
Reply with quote

Hi friends,

I'm looking for the AIBRETEN value, when DB2 stored procedure is accessing the IMS-DB and the end of IMS database is reached. This call is established using AERTDLI call and we pass AIB block in the call statement so as to capture the return code and various other fields.

I know that, The equivalent IMS status codes will be GE or GB and If AIBRETRN value is SPACE, then the IMS segment is found successfully.

Similarly, If the segment is not found or the end of IMS-DB is reached, what will be the AIBRETRN values.

Thanks,
Mahesh Urs
Back to top
View user's profile Send private message

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Tue Nov 13, 2007 4:12 am    Post subject:
Reply with quote

You might start exploring (the first link in my signature) and amongst the results find this though I don't know if it satifies your question. If not; feel free to explore some more.
Back to top
View user's profile Send private message
maheshurstd

New User


Joined: 16 Feb 2006
Posts: 14

PostPosted: Thu Nov 15, 2007 12:22 am    Post subject: Reply to: Need AIBRETRN value for end of IMS-DB in AERTDLI c
Reply with quote

Thanks for your reply.
But the link you gave is for queue manager and i'm looking for the AIBRETRN values returned from the IMS-DB to the DB2 after the "AERTDLI" call. Specially the value returned to DB2, when end of IMS database is reached.

Thanks,
Mahesh.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Thu Nov 15, 2007 2:28 am    Post subject:
Reply with quote

Well, asked a bit around and this was one of the answers. didn't explore them yet but have a look at it.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Thu Nov 15, 2007 2:51 am    Post subject:
Reply with quote

Quote:
The end of database is as you know indicated by the PCB status code GE or GB depending on the DLI call. If you have the AIB, then you can get to the
PCB, by using the AIBRSA1 field in AIB. This points to the PCB block/mask.

The DLI return & reason code values are the same for any IMS module (like
AERTDLI) that uses the AIB interface (as against the PCB interface). The IMS Messages and Codes, Volume 1: Appendix E (GC18-7827-00) book contains the list of return & reason codes and the IMS Application Programming:
Database Manager (SC18-7809-00) book contains the AIB & PCB masks.

For IMS V9, the books are online at:
http://www-306.ibm.com/software/data/ims/v9/v9index.html


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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am
No new posts Cobol EZASOKET call to SETSOCKOPT fails Andi1982 COBOL Programming 6 Thu Oct 06, 2016 7:12 pm
No new posts Strange EXEC function call in z/VM Willy Jensen CLIST & REXX 3 Wed Oct 05, 2016 2:07 pm
No new posts COBOL DB2 - CALL statement - high CPU... TS70363 DB2 15 Sun Sep 11, 2016 6:07 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us