Importing an ADABAS SYSOBJH Generated File
If you want to import a SYSOBJH file, the following must be true:
The SYSOBJH file must be an extact file.
The Adabas SQL Gateway server setup must be complete, and the CONNX Listener must be running on the mainframe.
The following configuration options affect this import:
If you want to keep the hyphens during the import, set the
KEEPHYPHENS configuration option to 1.
If you want to treat empty fields as a "0" or an empty string instead of SQL Null, set the
ESQNULL option to 0.
To import a SYSOBJH file:
1. Go to the main online CONNX Data Dictionary Manager page.
You can select CONNX Data Dictionary from the home page or the tile menu on the top right.
2. Browse to the CDD you want to import in and open it.
3. Click the Import button.
4. In the Import Type window, select ADABAS SYSOBJH Transfer from the dropdown menu and click OK.
5. In the Connection Information step, fill in the connection information in the respective fields and click Next:
a. The server address in the Server field.
b. The username for the server in the Username field.
c. The password for the server in the Password field.
d. The TCP/IP port in the TCP/IP Port field.
e. The database ID in the Database ID field.
f. Select a destination database from the dropdown menu. If you don't select a database, the destination database will default to a new one.
g. Turn the Use TLS/SSL option on if you want to use that functionality.
6. In the Import Properties step, enter your ADASCR password in the ADASCR Password field if you are using ADASCR.
7. Select a SYSOBJH transfer file from the list on the right and click Next.
To upload a SYSOBJH transfer file to the REST server from your machine, click the upload icon on top of the pane and browse to the local file you want to upload.
To download a SYSOBJH transfer file from the REST server to your machine, click the download icon next to it.
To delete a SYSOBJH transfer file on the REST server, click the trash can icon next to it.
8. In the Table Selection step, mark the tables you want to import in the Available Table(s) pane and press the arrow pointing to the right to move them to the Selected Table(s) pane.
You can use the search field in the Available Table(s) pane to filter the list of tables.
You can mark all tables in a pane by clicking the checkmark next to the Available Table(s) or Selected Table(s) entry.
You can move tables back from the Selected Table(s) pane by marking the tables and clicking the arrow pointing to the left.
9. In the Adabas COUNT Selection step, enter the number of maximum occurences for each field in the Max Count column.
You can use the Update Multiple Fields option to set the number of maximum occurences for all fields at the same time. To do so, set the option to on, input the number in the new field and click Apply to All Selected.
10. Click Done to finish the import procedure.