Load df file in Data Dictionary

andrew_simi

New Member
I dumped table to df file in Data Dictionary.
df file was generated, listed below:
Code:
ADD TABLE "table-name"
  AREA "Schema Area"
  DESCRIPTION "text"
  DUMP-NAME "filename"

ADD FIELD "a" OF "table-name" AS integer
  DESCRIPTION "text"
  FORMAT ">>>>>>>9"
  INITIAL "0"
  LABEL "text"
  POSITION 2
  MAX-WIDTH 4
  COLUMN-LABEL "text"
  ORDER 10
  MANDATORY

ADD FIELD "b" OF "table-name" AS character
  DESCRIPTION "text"
  FORMAT "x(3)"
  INITIAL ""
  LABEL "text"
  POSITION 3
  MAX-WIDTH 6
  COLUMN-LABEL "text"
  ORDER 20

ADD FIELD "c" OF "table-name" AS character
  DESCRIPTION "text"
  FORMAT "x(10)"
  INITIAL ""
  LABEL "text"
  POSITION 4
  MAX-WIDTH 20
  COLUMN-LABEL "text"
  ORDER 30

ADD INDEX "indexname" ON "table-name"
  UNIQUE
  PRIMARY
  INDEX-FIELD "a" ASCENDING
  INDEX-FIELD "b" ASCENDING
  INDEX-FIELD "c" ASCENDING

.
PSC
codepage=iso8859-2
.
0000001438
after that I'am trying to LOAD this file on another server also in DD and I got error which is listed on screen:

** Error during ADD TABLE table-name**
** Line 2 AREA Schema Area
Unknown TABLE keyword


I use OpenEdge 10.1A
 

Casper

ProgressTalk.com Moderator
Staff member
do you have a development license on that server?

If not, start datadictionary with the -rx parameter.
( for instance: TERM=vt100 mpro <path/to/db/dbname> -p dict.p -rx ).

Casper.
 

andrew_simi

New Member
It is working - thanks

also the environment variables PROCFG should be set on $DLC/progress.cfg.
Before I used different key.
 
Top