Introduction > Command Line Options

DMC has a command line options and can be used as a Runtime version, but only on your licensed computer.

Command line options are:

/P:X where X is the PROFILE ID (the ID is the GREEN column figure in the project & profile module)

/B:X where X is the PROJECT ID

/S:0 or /S:1 where 0 means NOT SILENT and 1 means SILENT running

You also need to set in Settings / Setup the checkbox to Open or not the Tool at the end of a Silent process treatment

Examples:

If you need to have all the Profiles in SQL projects processed, then use this command line argument (this will run all Project ID 1 Profiles SILENTLY):

x:\dmc.exe /B:1 /S:1

If you need to have the Profile ID # 2 processed, then use this command line argument (this will run Profile ID 2 Profiles where the IDE will open and you can see all processing taking place):

x:\dmc.exe /P:2 /S:0

**where x:\ is YOUR long path to the DMC executable.

When a command line process is finished then either the Interface will Open or not depending on your Settings

A log file is automatically done for all the different processes - you can find it in cgf_import sub directory under the Installation Directory - in a file called "dmclog.log" and you can open it in Notepad

This is an example of a batch on 6 profiles done from a simple Project ID Number (same TPS source Table transferred to six different SQL's DB's):

11:30:50 --> Start Data Transfer of Profile ID : 3 [1 / 6]

11:30:50 -->

11:30:51 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : Open Table OK

11:30:51 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : Load Data OK

11:30:52 --> TOPSPEED Source Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS) : List Columns OK

11:30:52 --> MySQL Destination Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) : Connection OK

11:30:52 --> MySQL Destination Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients) : Open Table OK

11:30:53 --> Load Complete Data : Source (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients)

11:30:53 --> Load Complete SQL Data : Destination (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients)

11:30:53 --> Start Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> theatrhall - cgf_clients)

11:31:16 --> Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL) ERROR : SQL Error:

90 - Error File System

42S22 - Unknown column 'CB_DATEEXP_TIME' in 'field list'

11:31:16 -->

11:31:16 --> MySQL Process interrupted before the end (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL)

11:31:16 -->

11:31:16 --> End Export to SQL Table (Profile : 3 [1 / 6] - TPSCLIEN.TPS -> Destination : MySQL)

11:31:18 -->

11:31:18 --> Start Data Transfer of Profile ID : 10 [2 / 6]

11:31:18 -->

11:31:18 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : Open Table OK

11:31:18 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : Load Data OK

11:31:19 --> TOPSPEED Source Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS) : List Columns OK

11:31:19 --> SQL Destination Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) : Connection OK

11:31:19 --> SQL Destination Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients) : Open Table OK

11:31:20 --> Load Complete Data : Source (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients)

11:31:21 --> Load Complete SQL Data : Destination (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients)

11:31:21 --> Start Export to SQL Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> suitecom_cgf - cgf_clients)

11:31:57 --> Export to SQL Table (Profile : 10 [2 / 6] - TPSCLIEN.TPS -> Destination : SQL) 9081 Records Transfered

11:31:57 --> End Export to SQL Table (Profile : 10 [2 / 6] - PSCLIEN.TPS -> Destination : SQL)

11:31:59 -->

11:31:59 --> Start Data Transfer of Profile ID : 11 [3 / 6]

11:31:59 -->

11:31:59 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : Open Table OK

11:31:59 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : Load Data OK

11:32:00 --> TOPSPEED Source Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS) : List Columns OK

11:32:00 --> DB2 Destination Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) : Connection OK

11:32:00 --> DB2 Destination Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS) : Open Table OK

11:32:01 --> Load Complete Data : Source (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS)

11:32:02 --> Load Complete SQL Data : Destination (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS)

11:32:02 --> Start Export to SQL Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> SUITECOM - CGF_CLIENTS)

11:32:57 --> Export to SQL Table (Profile : 11 [3 / 6] - TPSCLIEN.TPS -> Destination : DB2) 9081 Records Transfered

11:32:57 --> End Export to SQL Table (Profile : 11 [3 / 6] - PSCLIEN.TPS -> Destination : DB2)

11:32:59 -->

11:32:59 --> Start Data Transfer of Profile ID : 6 [4 / 6]

11:32:59 -->

11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : Open Table OK

11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : Load Data OK

11:33:00 --> TOPSPEED Source Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS) : List Columns OK

11:33:00 --> MySQL Destination Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) : Connection OK

11:33:01 --> MySQL Destination Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients) : Open Table OK

11:33:02 --> Load Complete Data : Source (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients)

11:33:02 --> Load Complete SQL Data : Destination (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients)

11:33:03 --> Start Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> db2727_test - cgf_clients)

11:33:40 --> Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 9081 Records Transfered

11:33:40 --> End Export to SQL Table (Profile : 6 [4 / 6] - TPSCLIEN.TPS -> Destination : MySQL)

11:33:42 -->

11:33:42 --> Start Data Transfer of Profile ID : 7 [5 / 6]

11:33:42 -->

11:33:43 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : Open Table OK

11:33:43 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : Load Data OK

11:33:44 --> TOPSPEED Source Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS) : List Columns OK

11:33:44 --> Oracle Destination Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) : Connection OK

11:33:44 --> Oracle Destination Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS) : Open Table OK

11:33:46 --> Load Complete Data : Source (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS)

11:33:48 --> Load Complete SQL Data : Destination (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS)

11:33:55 --> Start Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> XE - CGF_CLIENTS)

11:35:01 --> Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> Destination : Oracle) 9081 Records Transfered

11:35:01 --> End Export to SQL Table (Profile : 7 [5 / 6] - TPSCLIEN.TPS -> Destination : Oracle)

11:35:03 -->

11:35:03 --> Start Data Transfer of Profile ID : 5 [6 / 6]

11:35:03 -->

11:35:04 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : Open Table OK

11:35:04 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : Load Data OK

11:35:05 --> TOPSPEED Source Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS) : List Columns OK

11:35:05 --> MySQL Destination Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) : Connection OK

11:35:05 --> MySQL Destination Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients) : Open Table OK

11:35:07 --> Load Complete Data : Source (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients)

11:35:08 --> Load Complete SQL Data : Destination (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients)

11:35:14 --> Start Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> option_photo - cgf_clients)

11:36:12 --> Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> Destination : MySQL) 9081 Records Transfered

11:36:12 --> End Export to SQL Table (Profile : 5 [6 / 6] - TPSCLIEN.TPS -> Destination : MySQL)

11:36:12 -->

11:36:12 --> End of all Processes

As you can see from this example any ERROR is logged and the process stops and returns automatically to the next one

When running in SILENT mode the only way to know where about the processes are is by moving the mouse OVER the SYSTEM TRAY icon : it displays the process number and details of Source and destination table Names

LICENSING: As you may need to distribute DMC to your clients so as to let them use command line options, you will then need to purchase the RUNTIME VERSION of DMC.