Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE
THROUGH CL?

Question Posted / sony

Answers were Sorted based on User's Feedback



YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?..

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

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?..

Answer / cyjil

USING THE COMMAND 'RGZPFM'

Is This Answer Correct ?    9 Yes 1 No

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?..

Answer / nitendra chaurasia

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

YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?..

Answer / gatla

CL.... Only for displaying data in a FILE..

we can't update/delete/insert data into a file through CL PROGRAM...

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB400 Interview Questions

I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  

wirte a simple program for read file in cl

2 Answers   Active Brains,

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  

what is exception and how many types of exception

1 Answers   Active Brains,

what is general and type of general

1 Answers   Active Brains,

How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,

How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  

What is the batch job?

0 Answers  

A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  

what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,

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 the interactive job? What is the batch job?

0 Answers  

For more DB400 Interview Questions Click Here
Categories