topic Re: Database Creation in Operating System - HP-UX

Database Creation

Shabbir Shaikh — Mon, 09 Mar 2009 03:32:49 GMT

Hi,

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

Re: Database Creation

Ben Dehner — Mon, 09 Mar 2009 16:51:47 GMT

This type of ".d" file looks like Progress data definition data files. Is this a Progress database?

Re: Database Creation

Shabbir Shaikh — Sat, 21 Mar 2009 04:30:19 GMT

Yes

It is Progress83d

Re: Database Creation

Ben Dehner — Mon, 23 Mar 2009 17:52:11 GMT

Assuming that you are following the standard Progress naming conventions, you're missing the schema definition.

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.

Re: Database Creation

Shabbir Shaikh — Tue, 24 Mar 2009 07:26:32 GMT

Hi,

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

Re: Database Creation

Ben Dehner — Tue, 24 Mar 2009 16:52:31 GMT

The table definitions must be in the database before loading the contents. If you haven't loaded a definitions (DF) file, you can't load the data. Do you have a definitions file, and is it loaded? Try dumping the data definitions and see if it produced any output. Or if it will let you.