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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

CLRPFM Vs DELETE (SQL DELETE)

2 posters

Go down

CLRPFM Vs DELETE (SQL DELETE) Empty CLRPFM Vs DELETE (SQL DELETE)

Post  maran Mon Jul 27, 2009 7:52 pm

CLRPFM Vs DELETE (SQL DELETE)

Which one is better? why??
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

CLRPFM Vs DELETE (SQL DELETE) Empty Re: CLRPFM Vs DELETE (SQL DELETE)

Post  maran 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.
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

CLRPFM Vs DELETE (SQL DELETE) Empty Re: CLRPFM Vs DELETE (SQL DELETE)

Post  maran Mon Jul 27, 2009 7:52 pm

Agree with Razuk.

Anything else...?
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

CLRPFM Vs DELETE (SQL DELETE) Empty Re: CLRPFM Vs DELETE (SQL DELETE)

Post  muthuraman 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

Back to top Go down

CLRPFM Vs DELETE (SQL DELETE) Empty Re: CLRPFM Vs DELETE (SQL DELETE)

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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