COBOL-DB2 under BMC AR/CTL getting -927

pramod prasad · New User Joined: 20 May 2007 Posts: 6 Location: hyderabad

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.

dbzTHEdinosauer · Posted: Mon Apr 18, 2011 11:53 pm

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.

pramod prasad · New User Joined: 20 May 2007 Posts: 6 Location: hyderabad

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?

dbzTHEdinosauer · Posted: Tue Apr 19, 2011 6:36 pm

ATTACH(TSO|CAF|RRSAF)

link is:
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.