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: 10274
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: 10274
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 Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm


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