Command line imports must be performed from the CONNXCDD32.EXE Data Dictionary Utility install location. The default location is C:\CONNX32\UTILS.
To import COBOL copybooks from the command line, the syntax is as follows:
connxcdd32.exe <cdd path> <server name> <server userID> <server pwd> [<ssl | nossl>] import <import type> <import specification (copybook location) > <physical path of ISAM file> <SQL table name>
Example for Microfocus command line import without SSL:
connxcdd32.exe c:\cdd\importtest.cdd
aixserver user password nossl import MFFD /user/fd/CUSTOMER.CPY /test1/customer.dat
CUST01
Example for Dataflex command line import without SSL:
connxcdd32.exe c:\cdd\testcommandlineimport.cdd localhost user password nossl import DATAFLEX c:\connx32\utils NA
To import Adabas files from the command line, the syntax is as follows:
connxcdd32.exe <cdd path> <server name> <server userID> <server pwd> [<ssl | nossl>] import <import type> <database number> <input file>
Example for Adabas SYSOBJC command line import using an SSL connection:
connxcdd32.exe c:\cdd\importtest.cdd localhost myuser mypassword ssl import ADAOBJ 1 e:\workarea\EMPLOYEES_VEHICLES_FNR011_12.systrans
Note: if neither ssl nor nossl is specified, the import will default to nossl.
The list of valid import types:
|
RMS text specification file |
RMSTXT |
| RMS VAX or Alpha CDD | RMSCDD |
| RMS Powerhouse PDL files | RMPDL |
| RMS COBOL FD files | RMSFD |
| RMS SCT COBOL FD files | RMSSCT |
| RMS SCT Datamart COBOL FD files | RMSSCTDM |
| RMS DIBOL files | RMSDIBOL |
| RMS Formatted DDL | RMSDDL |
| RMS VAX Basic file | RMSBASIC |
| PowerFLEX files from directory | DATAFLEX |
| RDB database RDB | DATAFLEX |
| DBMS Codasyl database | DBMS |
| DB2 database | DB2 |
| Oracle database | ORACLE |
| Desktop OLEDB/ODBC Adapter | DESKTOP |
| Enterprise OLEDB/ODBC Adapter | ENTERPRISE |
| SQL Server | SQLSERVER |
| Sybase | SYBASE |
| Informix | INFORMIX |
| VSAM text specification file | VSAMTXT |
| VSAM COBOL FD files | VSAMFD |
| VSAM SCT COBOL FD files | VSAMSCT |
| VSAM SCT Datamart COBOL FD files | VSAMSCTDM |
| IMS database | IMS |
| IMS Index text specification file | IMSTXT |
| CISAM text specification file | CISAMTXT |
| CISAM COBOL FD files | CISAMFD |
| CISAM Powerhouse PDL files | CISAMPDL |
| CONNXStore | CONNXSTORE |
| ADABAS FDT Import | ADAFDT |
| ADABAS Import - SYSOBJH Transfer Format | ADAOBJ |
| ADABAS Dynamic DDL Import | ADADDL |
| DISAM text specification file | DISAMTXT |
| DISAM COBOL FD files | DISAMFD |
| MicroFocus text specification file | MFTXT |
| MicroFocus COBOL FD files | MFFD |
| SQLite database | SQLITE |
| RM/Cobol text specification file | RMTXT |
| RM/Cobol FD files | RMFD |
| JMS Import | JMS |
| Change Data Capture Target | CDC |
| ReDIS | REDIS |
| MySQL | MYSQL |