Grab the Opportunity
DB2 400 INTERVIEW QUESTIONS & ANSWERS
DB2/400 – Database Files
A
1) Physical
File has only ONE record format while Logical file can have multiple format.
2) Physical
file having data member while Logical
file won’t have data member.
3) Logical
File is an access path or it is just a View to Physical File.
4) Logical
file can have maximum of 32 record formats in one LF.
5) With
the help of LF and PF we can update the files.
6) Join
logical file joins two or more than two PFs. Maximum we can join 32 files in
one single join logical file. It can have multiple record format upto 32 record
format. We can not update the file with
help of JLF.
Q How
Unique record can be obtained in PF?
A With
help of file level key-word UNIQUE
Q Use of
Select / Omit Operation?
A It
is basically used in Logical File, with the help of SELECT we can select the
record and OMIT we can omit records based on certain condition which
specified in the KEYWORD area.
Q How
do I control the set of values in logical file?
A To
control the values / records in logical file we can use SELECT or OMIT along
with the required value or expression.
Q What
is level check ?
A 1) With respect to file
Specifies whether the level identifiers
of the record formats in the file are checked when the file is opened by a program at
run-time. If LVLCHK is *YES at the time
of creation of file.
2)
With respect to program
If LVLCHK is *YES at the time of creation
of file. And if there is any change in the file then we need to recompile the program.
No comments