Re: Embedded SQL in RPG

[mwalter@xxxxxxxxxxxxxxx]

The indicator variable is a small integer defined 5i 0 in the d-spec. I
code them like this.

 C/exec sql
 C+ FETCH c INTO :rtnVal :null
 C/end-exec

Where :null is the indicator variable.

I think you could use the COALACE() Scalar function as well.



Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                                
                                                          
                      "Erhardt, Bill"                                           
                                                          
                      <Bill.Erhardt@BDHHI.        To:       "Midrange List 
Questions (MIDRANGE-L@xxxxxxxxxxxx)" <MIDRANGE-L@xxxxxxxxxxxx> 
                      com>                        cc:                           
                                                          
                      Sent by:                    Subject:  Embedded SQL in RPG 
                                                          
                      midrange-l-bounces@m                                      
                                                          
                      idrange.com                                               
                                                          
                                                                                
                                                          
                                                                                
                                                          
                      08/10/2004 01:49 PM                                       
                                                          
                      Please respond to                                         
                                                          
                      Midrange Systems                                          
                                                          
                      Technical Discussion                                      
                                                          
                                                                                
                                                          
                                                                                
                                                          




I'm trying to find out how to code the following SQL statement.  I'm doing
a
left outer join of file a to file b.  on filed Z.  Some of the values for
field Z do not exist in file b so SQL is returning null values for those
fields.  My RPG program is getting a negative value in the SULKED field and
when I look at the job log I get the following:
Indicator variable required
My question is how do I define the indicator variable?



-----------------------------------------
This message was scanned for viruses.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.