RE: Using Array Values in Insert Query ?

Rob's example shows you.  Just use a host variable for the # Records also.

       nbrRowsToInsert = 5;
      /end-free

     C/EXEC SQL
     C+ insert into rob/thatfile
     C+ :nbrRowsToInsert rows
     C+ values (:testary)
     C/END-EXEC



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 Luqman
> Sent: Friday, February 18, 2005 1:33 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Re: Using Array Values in Insert Query ?
> 
> 
> Thats really nice of you, all of you given me  very 
> beneficial solutions. I
> really appreciate.
> 
> One thing I would like to clarify by myself that its not 
> necessary that I
> have to Insert 25 records all the time, it could be even 1 or 
> 2 records, so
> how can I check this and put that number in Insert Block Statement.
> 
> For example: say I have just 2 records to be inserted out of 25 and
> remaining 23 array elements are not used, will Insert Query 
> detect this
> automatically or I have to put number of rows to be inserted.
> 
> >      C/EXEC SQL
> >      C+ insert into rob/thatfile
> >      C+ 2 rows
> >      C+ values (:testary)
> >      C/END-EXEC
> 
> 
> Best Regards,
> 
> Luqman
> 
> 
>