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.

 

To import COBOL copybooks from the command line, the syntax is as follows:

connxcdd32.exe <cdd path> <server name> <server userID> <server pwd> import <import type> <import specification (copybook location) > <physical path of ISAM file> <SQL table name>

Example for Microfocus command line import:

connxcdd32.exe c:\cdd\importtest.cdd aixserver user password import MFFD /user/fd/CUSTOMER.CPY /test1/customer.dat CUST01
 

Example for Dataflex command line import:

connxcdd32.exe c:\cdd\testcommandlineimport.cdd localhost user password 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> import <import type> <database number> <input file>

Example for Adabas SYSOBJC command line import:

connxcdd32.exe c:\cdd\importtest.cdd localhost myuser mypassword import ADAOBJ 1 e:\workarea\EMPLOYEES_VEHICLES_FNR011_12.systrans

 

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