× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.