Suppose if a physical file is having 1000 records, but i
deleted 500 records from it. Here the concern is can the size
of the file changes or it remains the same... kindly help me
out with thorough xplanation.... Thanks in-advance...
Answers were Sorted based on User's Feedback
Answer / pavana
No, the size of the file does not change.
Use DSPOBJD on the PF before and after deleting records in the PF and see the difference.
The size of the PF before and after deleting records is same.
| Is This Answer Correct ? | 12 Yes | 0 No |
SIZE Won't change....
after deleting 500 records from 1000 records...
and then IF you want to insert NEW RECORDS
THAT RECORDS WILL ADDED AFTER THE 1000TH RECORDS PLACE......
BUT IF YOU WANT USE THE SPACE OF DELETED RCDS USE...
RCZPFM ON THAT PF...
THEN SIZE CHANGES...........
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pvenkatakishore
even i did RGZPFM the size of file can't change
is this right? give me answer
| Is This Answer Correct ? | 0 Yes | 1 No |
pls anyone explain about compile time array,pre run time array run time array
What is the use of member in pf?
wirte a simple program for read file in cl
Define interactive jobs and batch jobs
how to restrict upon adding the data for field reference file in DB400
What is FORMAT keyword and its use?
What is the difference between access path and open data path?
can any one pls tell me some differences between a LF and command OPNQRYF?
3 Answers Accenture, Cognizant, eFunds,
How to add a field to a PF and compile it without loss of data?
How we can't update join logical files?
one physical file can have how many max of logical files? what is the primary file?
What is the interactive job? What is the batch job? How to change the batch job to interactive job?