Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how to see number of logical files depending on a pf?...can
we declare more than 20 logical files from a single pf? is
it possible

Answers were Sorted based on User's Feedback



how to see number of logical files depending on a pf?...can we declare more than 20 logical files f..

Answer / swetha p rao

1. we can see the number of logical files in the following
ways
a. DSPDBR (filename)command
b. Using DBU (Filename) and Shift + F2

2. Yes we can declare more than 20 files on a physical file

Is This Answer Correct ?    15 Yes 1 No

how to see number of logical files depending on a pf?...can we declare more than 20 logical files f..

Answer / n muralidhar

I agree with swetha. But there is one more way to see the
logicals USING DBU is just type 'DBR' and press enter.

Is This Answer Correct ?    3 Yes 3 No

how to see number of logical files depending on a pf?...can we declare more than 20 logical files f..

Answer / krishna dahale

i am not agree wth swatha....bcoz thr is no such command in as400....and dbu is not wroking properly

Is This Answer Correct ?    0 Yes 0 No

how to see number of logical files depending on a pf?...can we declare more than 20 logical files f..

Answer / vinay

DBU is the Data Base Utility
Type DBU take F4 and enter File name and lib.
hear you take F14 (Shift + F2) it will direct to Data Base Relations

Is This Answer Correct ?    1 Yes 1 No

Post New Answer



More DB400 Interview Questions

how can we write LF using flatfile.

9 Answers  


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  


How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  


pls anyone explain about compile time array,pre run time array run time array

4 Answers  






What is the interactive job? What is the batch job?

0 Answers  


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


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

3 Answers  


Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  


What is the use of member in pf?

0 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,






Categories