View previous topic :: View next topic
|
Author |
Message |
abdulrafi
Active User
Joined: 14 Sep 2009 Posts: 184 Location: Coimbatore
|
|
|
|
Hi,
I am new to DB2 and I have developed some DB2 programs with embedded sql's and cursors. Now I am executing it and trying to find out the reason why it is not executing. It is not abending rather it is not getting executed.
Could anybody tell me how to start up with my analysis on this . Is there any log files to see the data until which the db2 processing is done or something like that ?.
Once my program abended with -912 i guess. i was unable to search for the plan whether it has been binded properly or not. If am wrong correct me please. |
|
Back to top |
|
|
Binop B
Active User
Joined: 18 Jun 2009 Posts: 407 Location: Nashville, TN
|
|
|
|
Hi Abdul,
Enjoy your stay in the Db2 world !!!
My suggestion for you is to check with your seniors on this ... Ask them to guide you for a simple program ... Make it work one time and then you can start with the actual code with all the cursors.. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
AdbulRafi, Hi,
Did you execute your SQL in SPUFI ? Did you get any results.
Post your full SQLCODE error message, so that other could help with your analysis.
Sushanth |
|
Back to top |
|
|
ChowHan
New User
Joined: 16 Oct 2009 Posts: 15 Location: India
|
|
|
|
Just a few more questions
Quote: |
Once my program abended with -912 i guess |
Are you sure? Did you put in a test for non-zero SQLCODE after open and fetch statements? or display SQLCODE in spool?
Did the cursor open successfully? Did it fail in fetch ?
Quote: |
It is not abending rather it is not getting executed. |
Is there some sort of conditional processing involved, where you cursor will be opened and rows fetched only if a certain condition is met?
Did you try debugging with expeditor (if its available in your shop)?
And as someone asked, did you run the cursor query in spufi? |
|
Back to top |
|
|
|