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
 

 

COBOL-DB2 under BMC AR/CTL getting -927

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pramod prasad

New User


Joined: 20 May 2007
Posts: 6
Location: hyderabad

PostPosted: Mon Apr 18, 2011 10:36 pm    Post subject: COBOL-DB2 under BMC AR/CTL getting -927
Reply with quote

Hi,

I have coded a COBOL-DB2 batch program under BMC AR/CTL, but during run time it is getting SQL code -927.
When I remove AR/CTL logic from my program it runs without any errors.
I have already defined my program in AR/CTL interface and NOT using DYNAM compiler option.
When I refer user manual it says
Not to use IKJEFT01 instead directly use program name in the JCL and during compilation A/R control library must be above DB2 library. Thats what exactly I am doing but still getting -927 while executing select query on very first table in my program.
SQL code: -927
SQLSTATE: 51006
SQLERRP: DSNELI SQL procedure detecting error.

Please advise me in getting this solved.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Mon Apr 18, 2011 11:53 pm    Post subject:
Reply with quote

If you are not using IKJEFT01,
that means you are making the db2 connect yourself.
something in your code is not triggering the AR/CTL interface to perform a connect for you.

I would go back to the user guide and find out what you have to do with your program - code/compilation/parms???
to have AR/CTL make the connect before you issue your first sql.

or,

I see you are linking to a DSNELI library, maybe it should be an RLI library
and AR/CTL makes the connect thru RRSAF.

DSNELI normally requires TSO connect.

are your db2 pre-compile parms set properly. they apparently are doing a ELI - TSO (CAF) connect and not utilizing the AR/CTL connect sub-system.

don't know anything about AR/CTL, but have played both with TSO/CAF and RRSAF.
go back to the manuel
or hope someone else has AR/CTL experience.
Back to top
View user's profile Send private message
pramod prasad

New User


Joined: 20 May 2007
Posts: 6
Location: hyderabad

PostPosted: Tue Apr 19, 2011 5:44 pm    Post subject: Reply to: COBOL-DB2 under BMC AR/CTL getting -927
Reply with quote

Thanks for your reply.

I am still struglling on this. Yes, I just observed that
DB2 attach type= CAF,
Which precompiler option should I use to disable this?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Apr 19, 2011 6:36 pm    Post subject:
Reply with quote

ATTACH(TSO|CAF|RRSAF)

link is:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z9.doc.apsg/src/tpc/db2z_descriptionprocessingoptions.htm

again, somewhere, someplace in your documentation from BMC, they
tell you what option to use.......if I had to guess, CAF.

also, it may not be the problem. the bmc wrapper (on your module)
has to know to make an attach. I don't think you are not configuring your wrapper properly. other wise you should have had an error message saying
the attach was unable to successfully complete - unless bmc writes errorhandling like the clowns that I work with.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts COBOL Programming Sandpit? jodrisco COBOL Programming 6 Wed Apr 12, 2017 3:47 am


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