Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

IMS DB2 program getting "SQL ERROR 0927"

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
arunparameswaran

New User


Joined: 12 Oct 2007
Posts: 8
Location: Trivandrum

PostPosted: Mon Feb 23, 2009 2:04 pm    Post subject: IMS DB2 program getting "SQL ERROR 0927"
Reply with quote

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?
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Feb 23, 2009 2:23 pm    Post subject: Reply to: IMS DB2 program getting "SQL ERROR 0927"
Reply with quote

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
Back to top
View user's profile Send private message
arunparameswaran

New User


Joined: 12 Oct 2007
Posts: 8
Location: Trivandrum

PostPosted: Mon Feb 23, 2009 2:40 pm    Post subject: IMS DB2 program getting "SQL ERROR 0927
Reply with quote

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?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon Feb 23, 2009 3:01 pm    Post subject: Reply to: IMS DB2 program getting "SQL ERROR 0927"
Reply with quote

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 icon_cool.gif
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
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us