Importing IMS Files
This section describes importing IMS files using the IBM® IMS™ Library Integrity Utilities for z/OS. You can also use a COBOL COPYBOOK in addition. If these utilities are not present on your system, you will need to import using an Index Text Specification file. See
IMS Index Text File Import Specification for more information.
It is possible to define a segment with only the key field information and then use the field definitions in a COBOL COPYBOOK to define the rest of the segment. In this case, you can use the COBOL FD import option.
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select IMS database in the Import Type list box.
3. Type the High Level Qualifier (HLQ) for the IMS subsystem you want in the IMS High Level Qualifier text box.
4. Choose one of the two possible IMS sources:
To choose the ACBLIB data set as a source, mark the
Use ACB checkbox.
To choose the PSBLIB and DBDLIB data sets as a source, click the
Load PSB/DBD button.
If this is the first time you import a file from this HLQ, you'll have to enter the login credentials to log in the database.
When done, the Load PSB/DBD button changes to Reset PSB/DBD.
5. Select the PSB from the IMS PSB Name drop-down list.
CAUTION:
You cannot import a PSB with a processing option of L (load PSBs). If you try to, you will get an error message.
6. Select the IMS database(s) you want from the IMS Database Name drop-down box.
The default value is <ALL>.
Note:
You can do step 5 and 6 in any order.
7. If you want to use a COBOL COPYBOOK, mark the Use COBOL FD checkbox and enter the fully qualified path to the IMS COBOL FD file in the text box below.
8. Enter the IMS subsystem ID in the IMS SSID text box and click OK.
9. Select the tables (segments) you want to import from the Available Tables list and click the Add>> button.
The tables will move from the Available Tables list to the Select Tables for Import list. If you want all the tables, click the Add All>> button to move all of the Available Tables to Select Tables for Import.
10. Click OK.
The selected tables appear under the PSB name in the CONNX Data Dictionary Manager dialog box. Selecting a table allows you to:
edit some of the table properties under the
Table Properties tab.
clone the table under the
Table Columns tab.
refresh the indexes under the
Table Indexes tab.
update the table security restrictions under the
Table Security tab.