CLRPFM

40 pts.
Tags:
CLRPFM
PF
When PF is Kept opened in One session that is I have done runqry on a PF ,and in the other session , if I try to do CLRPFM , it is not allowing .So if i want to delete the records of the fie if it is kept opened , what can be done ? Please clarify

Answer Wiki

Thanks. We'll let you know when a new response is added.

To do a CLRPFM, no other program can be using the file. So you need to end the othter program(s).
If you cannot do thet,, you can use an SQL SELETE statement. THis will removed the records, but the object size will not change because the records are still associated with the file as deleted records.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    But note that a SQL DELETE that has no WHERE clause may run CLRPFM. Therefore, it might be necessary to include something like WHERE COLUMN1 = COLUMN1 as part of the DELETE statement. Almost any test can be used in the WHERE clause as long as you know that it will select all of the rows you want to delete. Tom
    125,585 pointsBadges:
    report
  • Shobi
    [...] Having trouble using the CLFPRM command? CharlieBrowne and TomLiotta have the answer for [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following