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: 6970
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: 6970
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 to fetch the content by using s... arunc55 COBOL Programming 4 Fri Nov 17, 2017 1:25 pm
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts COBOL - EXIT statement weird behavior anthony.pangestu COBOL Programming 0 Fri Oct 27, 2017 9:57 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am

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