IBMi (AS400) fans only ' UTILITIES - How to retrieve physical file description

                               

 

This program allows you to see the information relating to a physical file (or Table) and its logical views on a 132-column screen.
This program also allows you to filter the columns of the key fields. This is very handy to check if the logical view we are looking for already exists.

Type FFD (F4)

Type physical file name end press ENTER

The program lists all column names with their attributes.

The program lists all column names with their attributes.

Type F5 to work with Logical wiew.

You can filter each column in this way:

Type 1 to select a row then ENTER:

The program show the keyfield list:

Finally, you can print the processing result: 

This is a way to retrieve physical file description and its logical view

If you are interested in this program Download FFD *SAVF 

If you have a profile on PUB400, type ADDLIBLE FFD11
then type FFD (F4)
then fill in the fields
TABLE_NAME (your table name on PUB400)
LIBRARY (your PUB400 library or *LIBL)

to test my FFD (Phisical file description) utility.

#IBMiSample

Need some help loading the *savf? 
HOW TO GET *SAVF FROM YOUR DESKTOP TO YOUR IBM I SYSTEM

I appreciate all the comments made on this blog.

I added a new feature - Create Phisical file Sql Source in QTEMP

For example, from the CLANA00F physical file I get the DLL:

--  Generate SQL                                                              

--  Version:                   V7R5M0 220415                                  

--  Generated on:              11/21/22 10:52:57                              

--  Relational Database:       PUB400                                         

--  Standards Option:          Db2 for i                                      

                                                                              

CREATE TABLE VDOTEST1/CLANA00F (                                              

--  SQL150B   10   REUSEDLT(*NO) in table CLANA00F in VDOTEST1 ignored.       

  STATO_CLIENTE_A_ANNULLATO FOR COLUMN CLANN0     CHAR(1) CCSID 273 NOT NULL  

  DEFAULT '' ,                                                                

  CODICE_CLIENTE FOR COLUMN CLCCL0     NUMERIC(7, 0) NOT NULL DEFAULT 0 ,     

  CODICE_INTESTAZIONE FOR COLUMN CLCIB0     CHAR(3) CCSID 273 NOT NULL DEFAULT

  '' ,                                                                        

  NOME_COGNOME_CLIENTE FOR COLUMN CLNOM0     CHAR(50) CCSID 273 NOT NULL      

  DEFAULT '' )                                                                

                                                                              

  RCDFMT CLANA      ;                                                         

                                                                              

LABEL ON COLUMN VDOTEST1/CLANA00F