Re: Deleting all records in a PF

[MWalter@xxxxxxxxxxxxxxx]

CLRPFM works fine if there isn't a trigger on the file. Otherwise, DELETE
FROM sql statement works about the quickest.

Thanks,

Mark

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


                                                                           
             Tony Carolla                                                  
             <carolla@xxxxxxxx                                             
             m>                                                         To 
             Sent by:                  RPG programming on the AS400 /      
             rpg400-l-bounces@         iSeries <rpg400-l@xxxxxxxxxxxx>     
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             04/04/2005 01:58          Re: Deleting all records in a PF    
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I use the CLRPFM command, because it seems to be quicker than 'DELETE FROM
LIB.TABLE', which (I believe) touches each record. How I wish SQL Server
had
this command ;-)

On Apr 4, 2005 10:43 AM, Douglas W. Palme <dpalme@xxxxxxxxxxxxxxxxxxxxx>
wrote:
>
> I know that I can use SQL to completely clear a physcial file, and in the
> end I might end up doing just that, but for educational purposes, what
> does
> everyone consider the easiest method of clearing all records using
> strictly
> RPGLE?
>
> --
> 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.
>
>


--
"Enter any 11-digit prime number to continue..."
--
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.