1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

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...

Question Posted / kkay

Answers were Sorted based on User's Feedback



Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / ram

size of pf didnt change until u run rgzpf...

Is This Answer Correct ?    15 Yes 0 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

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

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / karthik

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

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / abhay kumar

use rgzpfm filname then its size changed.

Is This Answer Correct ?    2 Yes 0 No

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

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

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the con..

Answer / abc

yes, the file size changes.

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More DB400 Interview Questions

What is the interactive job? What is the batch job?

0 Answers  

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...

6 Answers   ABC, TCS,

Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  

what is use of self join and which cases you will use this join

1 Answers   TCS,




one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,

How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  

How many libraries can be there in a library list?

2 Answers  

Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

0 Answers  

Last statement of any RPG pgm is LR?

5 Answers  

For more DB400 Interview Questions Click Here
Categories