CLRPFM
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
Software/Hardware used:
Software/Hardware used:
ASKED:
March 19, 2012 12:35 PM
UPDATED:
March 19, 2012 11:11 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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