Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

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

Question Posted / karthikeyango

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 to eliminate the level check error

2 Answers   TCS,

what is multiple member pf

1 Answers   Active Brains,

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

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

3 Answers   Cap Gemini,

How to know the particular record in pf with out reading?

0 Answers  

what is general and type of general

1 Answers   Active Brains,

how can we write LF using flatfile.

9 Answers  

How to find the list of source physical files in a library?

0 Answers  

how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

For more DB400 Interview Questions Click Here
Categories