Interviewer And Interviewee Guide

IBM DB400 Interview Question:

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?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online IBM DB400 Job Interview Questions And Answers
Copyright 2007-2025 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.

Interview Questions Answers .ORG