Re: Verify

[email protected] Fri, 26 Sep 2003 14:23:03 -0400
Newsgroups gmane.comp.systems.as400.code
Message-ID <OF9212FC78.5882AB0D-ON85256DAD.006466CE-85256DAD.0064FD0A@ground.fedex.com>
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-Zwy7GipZuJhWk0Htik3J/[email protected]>                                                
                      .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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/code400-l
or email: CODE400-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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





_______________________________________________
This is the CODE/400 Discussion & Support (CODE400-L) mailing list
To post a message email: CODE400-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/code400-l
or email: CODE400-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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