JDEdwards World (MOSC)

MOSC Banner

Is there a way to check the Logicals files for a physical and make sure they are correct?

edited Apr 12, 2012 11:09AM in JDEdwards World (MOSC)

Q - Is there a way to check the Logicals files for a physical and make sure they are correct?

A- Yes. You can use the IBM Command  Display Data Base Relations (DSPDBR) .

     At the long command line keyin DSPDBR and prompt with the F4 key.

     next keyin the physical file you what to review and press enter.

Example:  Employee Pay Instruction file F06106.

...+....1....+....2....+....3....+....4....+....5....+....6....+....7...
  12.04.12              Display Data Base Relations                    
DSPDBR Command Input                                                   
  File  . . . . . . . . . . . . . . . . . . . : FILE       F06106      
    Library . . . . . . . . . . . . . . . . . :            *LIBL       
  Member  . . . . . . . . . . . . . . . . . . : MBR        *NONE       
  Record format . . . . . . . . . . . . . . . : RCDFMT     *NONE       
  Output  . . . . . . . . . . . . . . . . . . : OUTPUT     *           
Specifications                                                         
  Type of file  . . . . . . . . . . . . . . . :            Physical    
  File  . . . . . . . . . . . . . . . . . . . :            F06106      
    Library . . . . . . . . . . . . . . . . . :            PGFDTA73    
    Member  . . . . . . . . . . . . . . . . . :            *NONE       
    Record format . . . . . . . . . . . . . . :            *NONE       
    Number of dependent files . . . . . . . . :               12  <------------------------Number of Dependent file (logicals)     

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center