itpragmatic
New Member
Experts,
I am a newbie to Progress. I have a created a database and i was able to create table in that db. Now i am dumping the files. tablename.p kind of files.
how should I use contents of .p (after dump this file is created tablename.p file) file. i want to know how i can import these contents now to execute the query (to create tables in the existing database)
the contents of .p files are as follows
DROP TABLE aj_purge_data_run_id.
CREATE TABLE aj_purge_data_run_id (
run_id integer FORMAT '->,>>>,>>9' LABEL 'RUN ID' COLUMN-LABEL 'RUN_ID' DEFAULT 0,
config_id integer FORMAT '->,>>>,>>9' LABEL 'CONFIG ID' COLUMN-LABEL 'CONFIG_ID' DEFAULT 0,
table_id integer FORMAT '->,>>>,>>9' LABEL 'TABLE ID' COLUMN-LABEL 'TABLE_ID' DEFAULT 0,
parent_table_id integer FORMAT '->,>>>,>>9' LABEL 'PARENT TABLE ID' COLUMN-LABEL 'PARENT_TABLE_ID' DEFAULT 0,
row_id character FORMAT '->,>>>,>>9' LABEL 'ROW ID' COLUMN-LABEL 'ROW_ID',
parent_row_id character FORMAT 'X(8)' LABEL 'PARENT ROW ID' COLUMN-LABEL 'PARENT_ROW_ID',
config_table_id integer FORMAT '->,>>>,>>9' LABEL 'CONFIG TABLE ID' COLUMN-LABEL 'CONFIG_TABLE_ID' DEFAULT 0,
row_num integer FORMAT '->,>>>,>>9' LABEL 'ROW NUM' COLUMN-LABEL 'ROW_NUM' DEFAULT 0
).
I would appreciate your ideas.suggestions.
Best regards.
I am a newbie to Progress. I have a created a database and i was able to create table in that db. Now i am dumping the files. tablename.p kind of files.
how should I use contents of .p (after dump this file is created tablename.p file) file. i want to know how i can import these contents now to execute the query (to create tables in the existing database)
the contents of .p files are as follows
DROP TABLE aj_purge_data_run_id.
CREATE TABLE aj_purge_data_run_id (
run_id integer FORMAT '->,>>>,>>9' LABEL 'RUN ID' COLUMN-LABEL 'RUN_ID' DEFAULT 0,
config_id integer FORMAT '->,>>>,>>9' LABEL 'CONFIG ID' COLUMN-LABEL 'CONFIG_ID' DEFAULT 0,
table_id integer FORMAT '->,>>>,>>9' LABEL 'TABLE ID' COLUMN-LABEL 'TABLE_ID' DEFAULT 0,
parent_table_id integer FORMAT '->,>>>,>>9' LABEL 'PARENT TABLE ID' COLUMN-LABEL 'PARENT_TABLE_ID' DEFAULT 0,
row_id character FORMAT '->,>>>,>>9' LABEL 'ROW ID' COLUMN-LABEL 'ROW_ID',
parent_row_id character FORMAT 'X(8)' LABEL 'PARENT ROW ID' COLUMN-LABEL 'PARENT_ROW_ID',
config_table_id integer FORMAT '->,>>>,>>9' LABEL 'CONFIG TABLE ID' COLUMN-LABEL 'CONFIG_TABLE_ID' DEFAULT 0,
row_num integer FORMAT '->,>>>,>>9' LABEL 'ROW NUM' COLUMN-LABEL 'ROW_NUM' DEFAULT 0
).
I would appreciate your ideas.suggestions.
Best regards.