Re: [WDSCI-L] Debugging embedded SQL & Sql statements

[Vadim Berestetsky <berestet@xxxxxxxxxx>]

Hi Diane,

Let me try to make some suggestions on various points:
1) What are you seeing in the debugger now? It might be helpful in this
case to compile
your program with the *LISTING debug view.
2) This is a good question. Do you have any sample programs with the
embedded sql
statements that you could forward to us? I'd like to give it a try in our
environment. Could
you please send them to my e-mail address below.

Thanks,
Vadim.
Internet:  berestet@xxxxxxxxxx



                                                                           
             infosys5@xxxxxxx                                              
             Sent by:                                                      
             wdsci-l-bounces@m                                          To 
             idrange.com               Websphere Development Studio Client 
                                       for iSeries <wdsci-l@xxxxxxxxxxxx>  
                                                                        cc 
             10/26/2004 10:58                                              
             AM                                                    Subject 
                                       [WDSCI-L] Debugging embedded SQL  & 
                                       Sql statements                      
             Please respond to                                             
                 Websphere                                                 
                Development                                                
             Studio Client for                                             
                  iSeries                                                  
                                                                           
                                                                           




Group,
I'm testing the WDSC interactive debugger with a program that has embedded
sql statements - (working from an example for the embedded sql),  here are
my questions:

1) When debugging in WDSC with embedded sql - I haven't found a way to
view the actual statement.
2)  When debugging from WDSC, without me having a breakpoint on the
embedded sql statement, the debugger stops - I have to select "resume"
each time to resume the debugger.
3)  And where can a find a reference that displays all the sql status
codes?  After I do a "Fetch from MyCursor" statement, I am checking the
sqlstt code for 01503, this works until I come to status code "22008" -
it's time I figure out what all these codes mean??

Thanks for any help.
Diane Mueller
_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.