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
 
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: 6968
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: 6968
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. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm

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