RE: embedded sql and nulls

You need to specify a null indicator, one for each column that you
fetch.   Then you must check to see if the null indicator is -1( is
null) or 0(not null).

Andrew 

-----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.


Note: This message, including attachments, is from H&R Block Financial Advisors,
Inc., Member NYSE, SIPC.  This is not a solicitation of any order to buy or 
sell.  The
information contained herein is deemed to be reliable but is in no way 
warranted by us as
to accuracy or completeness.  Messages are monitored and retained by the 
Company, but
the company cannot guarantee the security of this message.  The company, and its
associates, may not accept orders to affect purchase or sale transactions, 
accept funds,
securities, or similar instructions via email.  If you are not the intended 
recipient of this
message promptly delete this message and notify the sender of the delivery 
error by
return email or calling 1.800.HRBLOCK and selecting the option for 'Financial 
Services'
You may not forward, print, copy, distribute, or use the information in this 
message if
you are not the intended recipient.