CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with Database Objects in CONNX | CONNX Basics | Working with CDDs | Importing from the Command Line
 
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