Physical File
Questions on above session:
Using the command CRTLIB, create a Library TEST suffixed by your user name.
Check whether your library has been created using following commands:
WRKLIB or DSPLIB. Add the created library to the library list using commands
ADDLIBLE or EDTLIBL
Check your current library using DSPLIB and DSPLIBL.
Display libraries of all the users using command DSPLIB with *ALL as the value for the
parameter LIB.
Using the command CHGCURLIB change your current library to library which you have
created and check whether it has been changed by using the command DSPLIBL.
Try WRKSPLF and WRKUSRJOB commands.
Print all the libraries in your library list to a spooled file using the command DSPLIBL
OUTPUT (*PRINT) and view the spool file.
Display all the commands starting with ‘CRT’ by using the command SLTCMD CMD (CRT*).
Using the command DLTLIB, delete the library, which you have created above.
Questions:
Q1. What is an externally defined file? What two types are supported on the AS/400?
___________________________________________________________________________
___________________________________________________________________________
Q2 . Explain how any field included in the file in an ascending or descending order may process a
physical file. “Sorting” is not an acceptable answer.
___________________________________________________________________________
___________________________________________________________________________
Q3. Name the steps followed for building a physical file.
___________________________________________________________________________
___________________________________________________________________________
Q4. How many record formats may be included in a physical file?
___________________________________________________________________________
___________________________________________________________________________
Q5. What is the function of the following physical file keywords?
___________________________________________________________________________
___________________________________________________________________________
COLHDG EDTWRD REFLD
DESCEND LIFO TEXT
EDTCDE REF UNIQUE
Q6 What CL command is used to display he attributes of a physical file? Name the CL command needed
to display the field attributes of a physical file.
________________________________________________________________________
___________________________________________________________________________
Q7 Explain the function of he following physical file maintenance commands:
CHGPF CLRPFMCPYF
DSPPFM RMVM DLTF
Q8 How many default members are assigned when a physical file is created without changing any
parameters? How is a file created to support more than one member?
S S R Chowdary
Physical File
___________________________________________________________________________
___________________________________________________________________________
Q9. By what methods may data be loaded to a physical file?
___________________________________________________________________________
___________________________________________________________________________
S S R Chowdary