- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Database Creation
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2009 08:32 PM
тАО03-08-2009 08:32 PM
Database Creation
I have following files in .d format and i have to create database with that files.
-rw-r----- 1 root sys 173 Mar 5 11:48 nar_cmmt.d
-rw-r----- 1 root sys 791 Mar 5 11:48 xb2_ctrl.d
-rw-r----- 1 root sys 179 Mar 5 11:48 xb2_dlya.d
-rw-r----- 1 root sys 180 Mar 5 11:48 xb2_dlyc.d
-rw-r----- 1 root sys 179 Mar 5 11:48 xb2_errl.d
-rw-r----- 1 root sys 177 Mar 5 11:48 xx_ref_e.d
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2009 09:51 AM
тАО03-09-2009 09:51 AM
Re: Database Creation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-20-2009 09:30 PM
тАО03-20-2009 09:30 PM
Re: Database Creation
It is Progress83d
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-23-2009 10:52 AM
тАО03-23-2009 10:52 AM
Re: Database Creation
In Progress, the .d files are data export files. These file types only contain the table data, not the table definitions. You also need a .df schema definition file. This file defines the table structure, indexes, sequences and so forth. The basic procedure to create the Progress database would be:
1) create the empty database:
prodb mydb empty
2) import the data definitions from the .df file:
_progres -1 mydb
Tools -> Data Dictionary
Admin -> Load Data and Definitions -> Data Definitions (.df file)
-- here you would specify the .df file that you apparently don't have
3) now load your data:
_progres -1 mydb
Tools -> Data Dictionary
Admin -> Load Data and Definitions -> Table Contents (.d file)
-- now you would load the data for each one of the .d files that you do have
Without the .df file, you're out of luck. While it would be possible to create a database and manually build the tables to load the data, presumably that there is an application that references specific column names and/or indexes that you won't know.
Incidentally, you haven't mentioned what version of HP-UX you are running. Progress 8 was de-supported long ago, and I'm not sure that it will run on HP-UX 11i. In addition, Progress did not support anything on Itanium until version 10.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2009 12:26 AM
тАО03-24-2009 12:26 AM
Re: Database Creation
I m not able to load .d file from table contents, actually it is not highlighted.
After Data Definition cursor directly goes to SQL View.
Thanks & Regards
Shabbir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2009 09:52 AM
тАО03-24-2009 09:52 AM