Importing from the Command Line
Command line imports must be performed from the CONNXCDD32.EXE Data Dictionary Utility install location. The default location is C:\CONNX32\UTILS.
Syntax Examples
The syntax to import COBOL copybooks 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>
Below is an example of the command syntax for importing Microfocus 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
The syntax to import Adabas files 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 ssl or nossl is not specificed, the import tool defaults to nossl.
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