Answers

Question and Answer:

  Home  IBM DB400

⟩ 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?

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.

 177 views

More Questions for you: