To import from Adabas files (Natural)

Notes:

  •  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 ESQLNULL to 0.

  1. The Adabas SQL Gateway server setup must be complete, and the CONNX Listener must be running on the mainframe.

  2. Click the Import button in the CONNX Data Dictionary Manager window.

  3. The Import CDD dialog box appears.

    natural.jpg
     

  4. Select Adabas Import SYSOBJ Transfer Format  in the Import Type list box.

  5. Enter a Dictionary Database ID in the text box.  

  6. Enter the name of a SYSOBJ extract file. If necessary, use the Browse button to locate a file on the network. Instructions on how to do are at OpenSystems are and Mainframe.

  7. Enter an ADASCR password, if you are using the ADASCR security method.

  8. 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."

  9. Enter a CONNX user name and password.

  10. Enter a TCP/IP port number. 6500 is the default TCP/IP port.

  11. Select a Destination Database for the imported tables. See Adding a Database Connection for more information.

  12. Click the OK button.

  13. The CONNX Import Table Selection dialog box appears. Select each file to import, and then click the Add or Add All button.

  14. 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.

    image9.gif
     

  15. 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.