Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print data dictionary to file on

Status
Not open for further replies.

zopista

Programmer
Oct 1, 2003
3
NZ
What command do I use to dump the data dictionary to disk on OSF1 ...

Thanks

Martin
 
Are you wanting to dump reports of the database to disk, or the schema definitions (ie: a .df)? You can do all of these through the Data Dictionary. Let me know more of what you're trying to do and I can give you specific commands. :)

Rich
 
Hey Rich,

Thanks for your reply. Both actually! We are ditching our Progress based system and our software supplier is offering us no assistance.

Thanks

Martin
 
You should be able to get both from the data administration.

Dumping to a .df:
1) Data Administartion
2) Admin Menu
3) Dump Data and Definitions
4) Data Definitions (.df file)...
5) Click Select Some...
6) * is entered by default, just click OK.
7) Every table is selected, Click OK
8) Select where you want the .df file to go and what name you want to use. Click OK.

Printing the schema info:
1) Data Administartion
2) Database Menu
3) Reports
4) Detailed Table
5) ALL is selected by default, click OK.
6) Select your output options and click ok.

You can also dump the data to .d's from the Admin menu. If you want to do this, you might try one table first so you can get an idea of what the data looks like - mainly because doing all of them at once could take a long time depending on how big your database is.

Hope that helps! :)

Rich
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top