Re: Null fields in SQLRPGLE.

[Marco Facchinetti <facchinetti@xxxxxxxxx>]

I understand your suggestion but my purpose is to get the
ability to chain the sql "nullind" to a field that will not
change if the numbers (or the order) of the fileds included
by the "SELECT *....". 
In the listing I posted the index of the nullarray (21) was
from the precompiler listing, actually if I remove, add or
change the order of the fields in the file is not anymore
21...

--- Jon.Paris@hal.it wrote:
> 
>  >> But this is not true anymore since I'm forced to
> identify the SQL
> %nullind whit an array and (of course) a fixed
> index. Any way out?
> 
> Yes.  Name the null fields individually and then use
> "Overlay" against the
> DS name to create the array that the pre-processor seems
> to need.  Like so:
> 
> 
>      D NullInds        DS
> 
>      D   Field1Ind                    5I 0
>      D   Field2Ind                    5I 0
>      D   Field3Ind                    5I 0
> 
>      D   NullArray                    5I 0 Dim(3)
> Overlay(NullInds)
> 
> This way you get to test the individual flags without
> resorting to array
> subscripts.
> 
> 
> 
> Alternatively you could use a constant to supply the
> subscript value and
> name the subscript appropriately.
> 
> 
> 
> +---
> | 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
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
+---
| 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
+---