Re: SQL null indicators: what am I doing wrong

[Eugen.Baum@xxxxxxx]

I lookead at SQL/400(Paul Conte/Mike Cravitz)'s book.
They're using this example

d customerI      ds                      occurs(csAryElem)
d                                                     based(csNullDsAd)
d     csNullAry                 5I 0     dim(CsColCnt)

but their "FETCH" stmt has for :CsRowCnt  ROWS
into :customerR  :customerI

may be that's what made the difference.

Thank You.




                                                                                
             rick baird                                                         
             <rick.baird@xxxxxxx                                                
             om>                                                             To 
             Sent by:                    RPG programming on the AS400 / iSeries 
             rpg400-l-bounces@mi         <rpg400-l@xxxxxxxxxxxx>                
             drange.com                                                      cc 
                                                                                
                                                                        Subject 
             07/21/05 12:40 PM           Re: SQL null indicators: what am I     
                                         doing wrong                            
                                                                                
              Please respond to                                                 
             RPG programming on                                                 
             the AS400 / iSeries                                                
             <rpg400-l@midrange.                                                
                    com>                                                        
                                                                                
                                                                                




Eugen,

I thought I tried that the first time, but got a run time error about
something like "wrong number of fields on fetch", so I changed it to
the way I posted it.

I changed it back like you said, and bang - it works now.

must have been 'user' error. ;)

thanks!

On 7/21/05, Eugen.Baum@xxxxxxx <Eugen.Baum@xxxxxxx> wrote:
>
> Try like this
>
> s3DSnull      s             5i 0 dim(12)
>
> and then "into  :s3DS :s3DSnull"
>
>
> Thak You.
>
>
> --
> 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.
>
>

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