IBM DB400 Question: Download Questions PDF
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?
Answer:
A1. Reading member 5 of myfilepf
CRTLF FILE(KCS/MYFILELF) SRCFILE(KCS/KC1) DTAMBRS
((KCS/MYFILEPF (MBR5)))
Or
ADDLFM FILE(KCS/MYFILELF) MBR(MYFILEBR) DTAMBRS
((KCS/MYFILEPF (MBR5)))
A2.For accounting purpose each month data can be stored as
12 different members.
So that we can easily access one month data or 12 months
together.
Easy to maintain 12 members in one PF file instead of 12 PF
Files.
CRTLF FILE(KCS/MYFILELF) SRCFILE(KCS/KC1) DTAMBRS
((KCS/MYFILEPF (MBR5)))
Or
ADDLFM FILE(KCS/MYFILELF) MBR(MYFILEBR) DTAMBRS
((KCS/MYFILEPF (MBR5)))
A2.For accounting purpose each month data can be stored as
12 different members.
So that we can easily access one month data or 12 months
together.
Easy to maintain 12 members in one PF file instead of 12 PF
Files.
Download IBM DB400 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to read a PF in reverse(from last rec to first) using CL? | How to find the list of source physical files in a library? Is there any way to get a list? |