Re: Null Capable Fields

        >Not a work around, a different way of working.
        >Use embedded SQL statements for IO. This allows you to then accept
the
        >null indicators in select statements.

        Bruce 

        It's not the fields from the file that's the problem.   He wants to
have 
        working variables(fields) in his program that are Null capable.

        John Carr



        From:   R. Bruce Hoffman@rbruceh on 10/12/99 07:40 AM
        To:     RPG400-L@RPG400-L@midrange.com@SMTP@EXCHCONNECT
        cc:      

        Subject:        Re: Null Capable Fields

        Not a work around, a different way of working.

        Use embedded SQL statements for IO. This allows you to then accept
the
        null indicators in select statements.

        bellis@ORIENTAL.COM wrote:
        > 
        > I sent this out before and didn't get any responses. I thought I'd
try it again.
        > 
        > We have fields within DB2 files defined as "Null Capable".
        > 
        > Within an RPG IV program we try to define fields using the "like"
keyword over
        > these null capable fields, or define fields using externally
described data
        > structures over the file with null capable fields.
        > However, none of these fields defined internally to the RPG
program keep the
        > null capable attribute.
        > i.e.   I cannot use the %NULLIND BIF on the field.
        > 
        > Here is a excerpt from the on-line AS/400 reference books (V4R4)
on this
        > subject:
        > "If the file used for an externally described data structure has
null-capable
        > fields defined, the null attribute is not used in defining the RPG
subfield."
        > 
        > Is there a way to define fields internal to RPG programs as null
capable?
        > If not, is there a work around for this?
        > 
        > Thanks,
        > Brian Ellis.
        > 




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---