IMS DB2 program getting "SQL ERROR 0927"

arunparameswaran · New User Joined: 12 Oct 2007 Posts: 8 Location: Trivandrum

Hi,

I am running an job with two steps. Both steps having IMS DB2 program. While running the program, i am getting "SQL ERROR 0927ERROR WHILE OPENING CURSOR FOR TABLE" and abending the second step. Both programs are compiled with same options but while executing the error happening only for the second step. The second program having cursor call to fetch and update the table. The DBR has been created and binding was done successfully for the second program too.

Compiler options given.

DB2 ===> YES (Y/N) DB2 VARIABLES ===> NO
OTHER OPTIONS ===> YES (Y/N to display other options)
SUPPRESS MESSAGES ===> NO (WY/N)

NAME: GNC2101 TYPE: SRC LANGUAGE: COBOL390

COMPILE ONLY ===> N DLITxxx INCLUDE FOR IMS ===> N
CICS ===> N DROP INCLUDE STMTS(LCT) ===> N
TRACK(CICS) ===> N IMS ONLINE ===> N
XPEDITER ===> Y DCD LISTING (COBOL ONLY) ===> N
GATEWAY ===> N SUBROUTINE (STATIC CALL) ===> N
EXPAND COPY ===> Y DROP LE (WGS 1.3/PLI) ===> N

After some times, I have tested with LCT components, recompiled and promoted the components; then the error was vanished and job rans fine.
Could anyone help me to understand about the significance of LCT component while binding?

The program in the first step does not have the LCT component and even if thats the situation, the first step was executed successfully. Why is it so?

enrico-sorichetti · Posted: Mon Feb 23, 2009 2:23 pm

what does the manual say about sql error 927, or is it -927

search the forums ( or google ) and You will find many similar topics

arunparameswaran · New User Joined: 12 Oct 2007 Posts: 8 Location: Trivandrum

Hi sorichetti ,

Thank you for your fast response. I am getting -927 Sql error. but i have reached with a solution of recompiling the component with LCT component. Then it works fine. I would like to get to know about the significance of LCT components and how we can avoid such components by changing the compiler options? Again the job having two steps with two IMS DB2 programs, only the second step is abending due to this error. First step does not have the LCT component and even if thats the situation, the first step was executed successfully. So what would be the problem with second step? If i am using Cursor in IMS DB2, is it a necessary use of LCT?

enrico-sorichetti · Posted: Mon Feb 23, 2009 3:01 pm

for the significant of the LCT component/acronym
You should not ask about a -927 db2 abend

but about the meaning of the various options of Your change management tools dialogs
which should be available in the docs or by pressing the PF1 key
or better ask Your peers about the standards in Your organization

You did not notice that I edited Your posts to get rid of the ...
fast response request
replying is on voluntary bases and responder time availability, not on Your urgency