RE: Problem w/SQL

Charles,

That did the trick. I took out the overlays, defined it as a MODS and it
compiled.

Thanks a million,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                                
                                                        
                      CWilt@xxxxxxxxxxxx                                        
                                                        
                      Sent by:                  To:       rpg400-l@xxxxxxxxxxxx 
                                                        
                      rpg400-l-bounces@m        cc:                             
                                                        
                      idrange.com               Subject:  RE: Problem w/SQL     
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      07/28/2004 10:10                                          
                                                        
                      AM                                                        
                                                        
                      Please respond to                                         
                                                        
                      RPG programming on                                        
                                                        
                      the AS400 /                                               
                                                        
                      iSeries                                                   
                                                        
                                                                                
                                                        
                                                                                
                                                        




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