Interview Questions: DB2/400 or DB2 UDB for i-series from V5R1

I have very less time so i will put the questions that I remember. Any body needing such more questions can write to me. Here are a few of them, I will keep adding to them:

1. How does a Field Reference File -FRF differ from a Physical file – PF

Ans:-
a. Field reference file is used for referring a field for the physical file
b. A FRF doesn’t contain any data
c. Object of FRF- file is not used in the programs

2. Name two major differences between a Physical file and Logical File

Ans:-
a. Physical file can be update where as the logical file can’t be updated
b. A logical file field can be renamed but the not the physical file field
c. A logical file field can be concatenated with another field but not the physical file filed.
d. A field in a logical file record format can also represent concatenation of two fields from physical file

3. Name types of Logical File and state three differences between a Logical file
& Join Logical File.

Ans:-
a. There are two types of logical files one is simple logical file and other is join logical file.
b. 1st difference is the simple logical file can be updated (By using the logical file as a access path to PF, we can updated the PF) but in can of Join logical file it is not possible
c. Simple logical file contains only one record format where as the Join logical file can contains multiple records
d. While creating the join logical file we can’t specify any parameter to *SRC where as we can defined to logical file.




4. Explain the usage of JFILE, JOIN, JFLD, JREF and where they are declared

a. “JFILE” is a record level key word is used to join two physical file in join logical file
b. A simple logical file contains one record format and has one file specified on “PFILE” level keyword.
c. The maximum number of fields in a record format is 80000.
d. “JOIN”


5. Usage of DYNSLT Keyword (or) how records are selected/omitted while reading a database file?