RE: embedded sql and nulls

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

You need to pass a host indicator array to give SQL someplace to put the NULL 
flags.

Here's an example from the manual:

EXEC SQL
SELECT COUNT(*), AVG(SALARY)
INTO :PLICNT, :PLISAL:INDNULL
FROM CORPDATA.EMPLOYEE
WHERE EDLEVEL < 18
END-EXEC.


Notice the INDNULL variable that allows your to check in your RPG to know if 
PLISAL is NULL or not.

HTH,


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Hatzenbeler, Tim
> Sent: Friday, April 15, 2005 1:57 PM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: embedded sql and nulls
> 
> 
> 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.
> 
>