Re: embedded sql and nulls

Are you checking your SQLERR or SQLSTT. I'll bet there is an error. You may
have to supply null indicator variables for the fields that may return null
The indicator variables are defined as 5i,0.

Sort of like this:

SEU==>
FMT **  ...+... 1 ...+... 2 ...+... 3 ...+... 4 .
055.00      C/exec sql
056.00      C+ FETCH c INTO :rtnVal :null
057.00      C/end-exec
058.00

Thanks,

Mark

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


                                                                           
             "Hatzenbeler,                                                 
             Tim"                                                          
             <thatzenbeler@cli                                          To 
             nitech.net>               "'RPG programming on the AS400 /    
             Sent by:                  iSeries'" <rpg400-l@xxxxxxxxxxxx>   
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       embedded sql and nulls              
             04/15/2005 01:56                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I have a query, that has nulls in some of the fields, but when I fetch, the
fields that don't have nulls, they to are blank...

So I was wondering, is the an SQL switch, that I need to set, to allow
NULLS, or do I have to add coalesc function to ever field, to return a non
null?

Thanks, tim

This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.