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
SQLERRP: DSNELI SQL procedure detecting error.
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.