PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

CLRPFM Vs DELETE (SQL DELETE)

View previous topic View next topic Go down

CLRPFM Vs DELETE (SQL DELETE)

Post  maran on Mon Jul 27, 2009 7:52 pm

CLRPFM Vs DELETE (SQL DELETE)

Which one is better? why??
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: CLRPFM Vs DELETE (SQL DELETE)

Post  maran on Mon Jul 27, 2009 7:52 pm

CLRPFM is to remove the reocrds in a file, Delete is to delete the records. But if we do CLRPFM the no. of deleted records spaces will remain whereas if we go for delete it will take off the space.
Example:
CLRPFM FileA (having 200 records) - after clearing there is noe records but, if we do DSPFD FileA, it will show the no. of records as 200.

SQL Delete -> after delete DSPFD FileA, It will shows as zero records.
_________________
Regards,
Razuk.
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: CLRPFM Vs DELETE (SQL DELETE)

Post  maran on Mon Jul 27, 2009 7:52 pm

Agree with Razuk.

Anything else...?
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: CLRPFM Vs DELETE (SQL DELETE)

Post  muthuraman on Fri Sep 25, 2009 5:58 pm

Here is advantage using SQL to clear the file:
CLRPFM need exclusive lock on the file but SQL DELETE do not need this - so in some cases it could be advantageous to use SQL.

muthuraman

Posts : 42
Join date : 2009-08-28

View user profile

Back to top Go down

Re: CLRPFM Vs DELETE (SQL DELETE)

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum