Importing from an IMS Database
CONNX uses the IBM® IMS™ Library Integrity Utilities for z/OS for this import. In addition, you can also use a COBOL copybok. If the utilities are not present on your system, you can import with an
IMS Text Specification File.
To import IMS data:
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 IMS Database 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 IMS High Level Qualifier IMS High Level Qualifier field.
f. The IMS subsystem ID in the IMS SSID field.
g. Turn the Use TLS/SSL option on if you want to use that functionality.
6. In the Import Properties field, do the following:
a. Select the IMS database(s) you want from the IMS Database Name dropdown menu.
b. Select the program specification block from the IMS PSB Name dropdown menu.
c. Turn the Use ACB option on if you want to use the access control block as a data source.
d. Turn the Import field definitions from COBOL Copybook option on if you want to use a COBOL copybook. Click Next when done.
7. If you turned the Import field definitions from COBOL Copybook option on, you are taken to the COBOL FD Selection step. Select a remote or local copybook.
If you want to use a remote copybook, click the
Remote Copybook radio button and enter a fully qualified library.sublib.member.type name in the
COBOL FD Dataset Member field, for example
cnxvvrr.copybook.customer.c. The file must reside in a library.sublib and the library must be defined to the TCP/IP file system.
If you want to use a local copybook, click the
Local Copybook radio button and select a file from the list.
To upload a copybook 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 copybook from the REST server to your machine, click the download icon next to it.
To delete a copybook on the REST server, click the trash can icon next to it.
8. If you did not turn the Import field definitions from COBOL Copybook option on, you are taken to 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. Click Done to finish the import procedure.
See
Specifying IMS Packed Decimal Data Fields after you complete the import. You can complete that task in the web based CDD manager.