CONNX provides an option to import metadata from scripts containing two of Software AG's specific SQL commands: CREATE TABLE DESCRIPTION and CREATE CLUSTER DESCRIPTION.
Note: If you wish to retain hyphens during a Windows import, you must first set the KeepHyphens variable.
Start your Adabas database.
Click the Import button in the CONNX Data Dictionary Manager window.
The Import CDD dialog
box appears.
Select Adabas Script DDL Import files in the Import Type list box.
To import multiple files, enter a Database ID number.
Add the DDL File Script number, or use the Browse button to locate the file.
Enter an ADASCR password, if you are using the ADASCR security method.
If the database you are importing from is located on the same Windows machine that you are importing to, enter "localhost" in the Server text box. For all other instances, enter the TCP/IP address or server name in the Server text box. The CONNX Listener Task attempts to access the given server. If the server is unavailable or cannot be located, the following message appears: "The CONNX Listener process (CNXRUN##_MAIN) is not running on the system."
Enter a CONNX user name and password.
Click the OK button.
CONNX searches for Master tables containing the various subtables. The CONNX Import Table Selection dialog box appears. Select a table, and then click the Add button.
The Adabas
Count Selection dialog box appears. Enter the number of maximum
occurrences of each field under Max
Repeat, and then click the OK
button.
Save the CDD by selecting
the File menu and then clicking
Save. The imported tables
appear in the CONNX Data Dictionary Manager window.
A script from the sample Employees file appears as follows. CONNX creates the various subtables as well as the relationships between the files.:
#######################################################################
# ASG Version : x.x.x.x
# Date/Time : 04/01/04 10:50:38
# File : 12:11
#######################################################################
create cluster description CLUSTER_11
database number 12
file number 11
(
create table description EMPLOYEES
(
COL_SEQNO_0 seqno(0) not null
,PERSONNEL_ID
shortname 'AA'
,FIRST_NAME
shortname 'AC'
,NAME
shortname 'AE'
,MIDDLE_I
shortname 'AD'
,MAR_STAT
shortname 'AF'
,SEX
shortname 'AG'
,BIRTH
numeric (6, 0)
shortname 'AH'
,CITY
shortname 'AJ'
,ZIP
shortname 'AK'
,COUNTRY
shortname 'AL'
,AREA_CODE
shortname 'AN'
,PHONE
shortname 'AM'
,DEPT
shortname 'AO'
,JOB_TITLE
shortname 'AP'
,LEAVE_DUE
shortname 'AU'
,LEAVE_TAKEN
shortname 'AV'
,primary key ( COL_SEQNO_0)
# Number of columns for this table: 17.
)
,create table description EMPLOYEES_ADDRESS_LINE
(
COL_SEQNO_0 seqno(0) not null
,COL_SEQNO_1 seqno(1) not null
,ADDRESS_LINE
shortname 'AI'
,foreign key ( COL_SEQNO_0) references EMPLOYEES
,primary key ( COL_SEQNO_0, COL_SEQNO_1)
# Number of columns for this table: 3.
)
,create table description EMPLOYEES_INCOME
(
COL_SEQNO_0 seqno(0) not null
,COL_SEQNO_1 seqno(1) not null
,CURR_CODE
shortname 'AR'
,SALARY
shortname 'AS'
,foreign key ( COL_SEQNO_0) references EMPLOYEES
,primary key ( COL_SEQNO_0, COL_SEQNO_1)
# Number of columns for this table: 4.
)
,create table description EMPLOYEES_BONUS
(
COL_SEQNO_0 seqno(0) not null
,COL_SEQNO_1 seqno(1) not null
,COL_SEQNO_2 seqno(2) not null
,BONUS
shortname 'AT'
,foreign key
(COL_SEQNO_0, COL_SEQNO_1)
references EMPLOYEES_INCOME
,primary key ( COL_SEQNO_0, COL_SEQNO_1, COL_SEQNO_2)
# Number of columns for this table: 4.
)
,create table description EMPLOYEES_LEAVE_BOOKED
(
COL_SEQNO_0 seqno(0) not null
,COL_SEQNO_1 seqno(1) not null
,LEAVE_START
shortname 'AX'
,LEAVE_END
shortname 'AY'
,foreign key ( COL_SEQNO_0) references EMPLOYEES
,primary key ( COL_SEQNO_0, COL_SEQNO_1)
# Number of columns for this table: 4.
)
,create table description EMPLOYEES_LANG
(
COL_SEQNO_0 seqno(0) not null
,COL_SEQNO_1 seqno(1) not null
,LANG
shortname 'AZ'
,foreign key ( COL_SEQNO_0) references EMPLOYEES
,primary key ( COL_SEQNO_0, COL_SEQNO_1)
# Number of columns for this table: 3.
)
);