.df or .d apply (definition structure) on Database

How to apply .df  or .d on Database

DF apply on Database isn't a difficult task, but if you apply wrong DF on wrong database it'll be a little headache for you!!!

".df" file is data definitions. This contains the definitions of tables, indexes and fields. Not the data inside of them. Typically you would load a .df file in order to create a new table or to add fields and indexes to an existing table.

Care to be taken on DF apply,

1. confirm on which database it should be applied.
2. make a note of the path where it is exactly.
3. ensure that no users are currently using the database (but never apply in single user mode).
4. get a proper downtime before apply.
5. ensure all the areas are present in the database.

As soon the downtime please down the database and start it with buffer of 10000 or more login with your credential to the Database, go to data dictionary

How to goto Data Dictionary mode

1. mpro <db-name>
• hit F3 goto tools>Data dictionary.
2. mpro <db-name> -p dict.p

once you go to Data dictionary

1. go to admin > load data and definition > Data Definition (.df)
• enter the full path of the .df file unless if it present in same directory where DB exist.
• check mark the stop on error field Press F1
• wait till it shows load is completed.

you are done with the .df load

How to apply .d

These files contain data that has been exported from one database which you then want to import into another database.

.d is also same way to be apply.

only difference is 

1. go to admin > load data and definition > Table contents (.d)
• enter the full path of the .d file unless if it present in same directory where DB exist.
• check mark the stop on error field Press F1
• wait till it shows load is completed.

You are done with the loading of .d