RE: RPG400-L Digest, Vol 3, Issue 231

["Uros Davidovic" <Uros_Davidovic@xxxxxxxxxxx>]

I thought that CHAIN is random retrieval and does not guarantee the 
retrieval of the first record. In this case, your example would not work. 
In reality, it most likely will, but why take the chance, as SETLL does 
not do an I/O anyhow, you are still looking at a single I/O to setup the 
loop. Of course, all this can be done with SQL as well... in a single 
statement...

-----Original Message-----
From: "John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Date: Fri, 26 Mar 2004 10:12:19 -0600
Subject: RE: RPG400-L Digest, Vol 3, Issue 231

> While his code would write a duplicate record at the bottom of the
> subfile,
> and your code may be efficient, my suggestion would be:
> 
> C     myklist       chain     myfile       
> C                   dow       NOT %eof(myfile) 
> C                   eval      rrn = rrn + 1
> C                   write     mysubfile    
> C     myklist       reade     myfile       
> C                   enddo     
> 
> JMHO
> John Brandt
> iStudio400.com
> 
> -----Original Message-----
> From: Marvin Radding [mailto:MRadding@xxxxxxxxxxxx]
> Sent: Friday, March 26, 2004 9:58 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: RPG400-L Digest, Vol 3, Issue 231
> 
> 
> 
> While there is nothing wrong with your code, I think this way is more
> effiecient.
> 
> C     myklist       setll     myfile       
> C                                          
> C                   dou       %eof(myfile) 
> C                                          
> C     myklist       reade     myfile       
> C                   if        %eof(myfile) 
> C                   iter                   
> C                   endif                  
> C                                          
> C                   eval      rrn = rrn + 1
> C                   write     mysubfile    
> C                                          
> C                   enddo                  
> 
> Marvin Radding
> 
> 
> message: 1
> date: Thu, 25 Mar 2004 14:32:35 -0800 (PST)
> from: simafrog <SimaFrog@xxxxxxxxxx>
> subject: SETLL ONE SLIGHT PROBLEM
> 
> Actually I don't think I can do this here anyway. One problem remaining
> is that the reade of the Detail file is causing one extra record to be
> added to the work file, the last one of the batch is duplicated. Here
> is
> the code:
>  C           BLD       BEGSR                               
>  C*                                                        
>  C           OHKEY     SETLLORDHEDR             40        
>  C*                                                        
>  C           *IN40     DOWEQ*OFF                           
>  C*                 
>                                                     
>  C           OHKEY     READEORDHEDR                 40    
>  C           *IN40     IFEQ '0'                            
>  C*                                                        
>  C           C*                                                        
>  C           ODKEY     SETLLORDDTL                   50    
>  C           *IN50     DOUEQ*ON     
>  C           ODKEY     READEORDDTL                   50      
>  C                     WRITEORDSWRKF                         
>  C                     END                                   
>  C                     END                                   
>  C                     END                                   
>  C*                                                         
>  C                     ENDSR                                 
>                        
> 
> 
> 
> 
> 
> _______________________________________________
> 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.
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.642 / Virus Database: 410 - Release Date: 3/24/04
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.639 / Virus Database: 408 - Release Date: 3/22/04
>  
> _______________________________________________
> 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.
>