YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE
THROUGH CL?
Answers were Sorted based on User's Feedback
Answer / bharathi
we can not update a PF from CL.
If we want to delete unused space in PF use CPYF or
RGZPFM. these are used to remove unused space.
Is This Answer Correct ? | 17 Yes | 1 No |
USING THE COMMAND 'RGZPFM'
The Reorganize Physical File Member (RGZPFM) command
compresses (removes deleted records from) one member of a
physical file in the database, and it optionally
reorganizes that member.
Is This Answer Correct ? | 7 Yes | 1 No |
What is the interactive job?
one physical file can have how many max of logical files? what is the primary file?
Which keyword is used both in subfile and subfile control record format of a DSPF?
In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.
what is open data path? and what is the diff b/w access path and open data path?
Last statement of any rpg program is lr?
How many max. Record format a logical file have?
I have a pf, it contains 5 members, how to access particular member data from logical file?
what is the difference between adding keys & constraints into a phisical file
I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?
There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.
what is general and type of general