Re: Verify

[phillip.groschwitz@xxxxxxxxx]

Here's what I do.  I have a source member named #cb_sqlca with the SQLCA
data structure, which you can get from qtemp/qsqltemp1 after attempting a
compile.

In my SQLRPGLE source, I add this:


     D/if defined(need_sql)
     D/include philsrc,#cb_sqlca
     D/endif

Then, do verify with prompt, select the compile tab, then add 'need_sql' at
define conditon names and press add.

If you don't condition it, then you will have errors during compile.

hth,
Phil





                                                                                
                                                   
                      "Johnson, Dan R."                                         
                                                   
                      <DRJohnson@columbia        To:       
<code400-l@xxxxxxxxxxxx>                                                
                      .com>                      cc:                            
                                                   
                      Sent by:                   Subject:  Verify               
                                                   
                      code400-l-bounces@m                                       
                                                   
                      idrange.com                                               
                                                   
                                                                                
                                                   
                                                                                
                                                   
                      09/26/2003 02:04 PM                                       
                                                   
                      Please respond to                                         
                                                   
                      CODE/400 Discussion                                       
                                                   
                      & Support                                                 
                                                   
                                                                                
                                                   
                                                                                
                                                   




Whenever I verify a program with embedded SQL I get a 7030 error for the
variable SQLCOD.  When I compile the program everything is fine.  For
some reason the verifier doesn't see SQLCOD as a valid program variable.

Has anyone else encountered this problem, and more importantly, is there
a workaround?

Thanks,
Dan

_______________________________________________
This is the CODE/400 Discussion & Support (CODE400-L) mailing list
To post a message email: CODE400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/code400-l
or email: CODE400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/code400-l.

NOTE: WDSc for iSeries disucssion has it's own mailing list.
Information can be found at
http://lists.midrange.com/cgi-bin/listinfo/wdsc-l