New .df adding into Database

jchellap

Member
Hi all,

I need to add a new .df file into the database to get a new table.

Should the database should be down before that ?

first time I am going to do this. so requesting your suggestions before doing the same.

thanks in advance
 
two comments:
1. no, the DB should not be down, but no other user should usw/lock records in DB
2. make sure you are loading the new df into seperate DB (for example i use xxdb)
instead of into qaddb
otherwise you will be forced to recompile all QAD programs
 
Hello jchellap,

Mosfin is right with the part that no other user should have acces to the data dictionary.
But you can load your new table in any database you like. You DON't have to compile all QAD programs. Preferably not in the HELP database.

Be aware that you have to create your own dump/load and or archive routines in relation to your end-users.

After loading the table, dump it with the Progress Data-Dictionary to find out the settings in for possible SQL selections.

Are you loading your table via data-dictionary or mfgutil?
 
Back
Top