Importing a SYSOBJH Generated File to CONNX
Keep the following in mind:
You must have a SYSOBJH extract file. Here are the instructions how to generate this file: Mainframe, OpenSystems.
The Adabas SQL Gateway server setup must be complete, and the CONNX Listener must be running on the mainframe.
If you wish to retain hyphens during a Windows import, you must first set the KEEPHYPHENS variable. The default is to have it unset (0).
If you desire to have Natural Logicals be treated as a Bit instead of a Byte (Default), you must set the ADA_NATURALBYTEASBIT variable to 1. The default is to treat Natural Logicals as a Byte field.
On Empty Fields (Fields in which the values are 0 or an empty string), CONNX treats these fields as a SQL Null by default. If you desire to have the fields be treated as a 0 or an empty string, you must set the variable ESQNULL to 0.
To import a SYSOBJH generated file:
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Adabas Import SYSOBJ Transfer Format in the Import Type list box.
3. Enter a Dictionary Database ID in the text box.
4. Enter the name of a SYSOBJ extract file. If necessary, use the Browse button to locate a file on the network.
5. Enter an ADASCR password, if you are using the ADASCR security method.
6. Depending on where the database you are importing from is located, enter the following in the Server text box:
Enter "localhost" if the database is on the same Windows machine.
Enter the TCP/IP address or server name for all other instances. 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."
7. Enter a CONNX user name and password.
8. Enter a TCP/IP port number.
The default port is 6500.
9. Select a Destination Database for the imported tables.
See Adding a Database Connection for more information.
10. Click the OK button.
11. The CONNX Import Table Selection dialog box appears. Select each file to import, and then click the Add or Add All button.
12. 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.
13. Save the CDD by selecting the File menu and then clicking Save.
The CDD appears under Adabas in the upper pane of the CONNX Data Dictionary Manager.