Re: How to optimize COPY *ADD

[rob@xxxxxxxxx]

I know that it is looked upon with scorn, buy why not make the file an
Input Primary with no key?
1)  You're not doing the keyed read
2)  And notice that little compiler message 'RPG handles the blocking for
you'?  I've found the compiler much more efficient in determining blocking
on a primary file than I've ever been able to duplicate in CL.

Lot's of other good suggestions out there though!

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.


                                                                                
                                         
                    "William Corbett"                                           
                                         
                    <corbett@asresource        To:     "MIDRANGE-L@midrange. 
com" <MIDRANGE-L@midrange.com>              
                    s.com>                     cc:                              
                                         
                    Sent by:                   Subject:     Re: How to optimize 
COPY *ADD                                
                    owner-midrange-l@mi                                         
                                         
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    07/27/2001 01:51 PM                                         
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




Dimitri,
I haven't tested this for several releases, but an RPG pgm used to be a LOT
faster than cpyf.
Delete and recreate the LF's if you can.
Don't use the "K"eyed read, do a ---- Read-DoW Not %eof-Write-Read ----
loop
and increase blocking factor in the CL.  You can cut down that time
significantly.

AS/Resources, Inc.
William A.(Tony) Corbett
IBM Certified Specialist - AS/400 Developer
http://www.asresources.com
corbett@asresources.com
404-784-4737


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---