RE: Problem w/SQL

Mark,

You shouldn't have to do it one at a time.

How about trying to take out the overlay(dataDS:*NEXT).  As far as I can see
you don't need them since all the fields are simple DS subfields.

Something else along the same line, I've not really used the
overlay(<...>:*NEXT) myself.  But every example I've seen from Scott and
Barbara have the first field defined simply overlay(dataDS), then the rest
defined with the *NEXT.  Don't know if it makes a difference but....


Charles


> -----Original Message-----
> From: mwalter@xxxxxxxxxxxxxxx [mailto:mwalter@xxxxxxxxxxxxxxx]
> Sent: Wednesday, July 28, 2004 9:42 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Problem w/SQL
> 
> 
> 
> First of all, the DS is global and not defined elsewhere. The 
> precompiler
> didn't like the 'FOR 15 ROWS' statement for some reason. I tried a
> dimensioned data structure, a MODS, and an array basing my DS 
> on the Array.
> No love. What I did was just retrieve into a basic DS and 
> loop 15 times to
> fill the subfile. Seems inefficient to do 15 fetches when one 
> is SUPPOSED
> to work. I'd love to get this code to function. But, onward 
> and upward.
> Thanks anyway for the help.
> 
> Thanks,
> 
> Mark
> 
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com
> 
> 
> --
> 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.
>