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

What is the purpose of the chain and setll and setgt?

0 Answers  


wirte a simple program for read file in cl

2 Answers   Active Brains,


Define interactive jobs and batch jobs

6 Answers  


How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,






what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,


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

3 Answers  


What is the primary file?

0 Answers  


How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers  


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


CRTDTA AND CRTARA should be used along with?

2 Answers  


Categories