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 |
what is use of self join and which cases you will use this join
what is open data base command
1 Answers Active Brains, Cognizant, CSC, CTS,
what is the purpus of the chain and setll and setgt ?
What is the interactive job?
A pf containing 100 records... my query is how to display from 11th record in the pf?
I have a PF with out any data but the dependent LF is having data?
When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why
How to add a field to a PF and compile it without loss of data?
How to index LF by relative record no (RRN)
I had created one physical file tell me command to enter data in to?
what is exception and how many types of exception
hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that