Port to SQL > Step ONE (Dictionary parsing)

AUTOMATED Process which will CREATE all SQL Tables and GENERATE a NEW DCTX File on NORMALIZED SQL

This is the LAST STEP in the Step 1 (DMC) Task :

1. All SQL Tables are created

2. All Data Transfer Profiles are created (option Data)

3. A New DCTX File is generated for you to (NEXT STEP) create a NEW Dictionary in Clarion

4. An INCLUDE File has been created and displayed (read it carefully as it contains very important information's)

5. A FOLDER (named from your DCTX File) containing ALL your files and sql scripts is created (also accessible from DMC's Navigation Panel under "Documents/Port to SQL")

6. All important files are copied for you to the Destination folder you selected in settings

DMC INCLUDE File (named "DMC_include_Global_Variables.clw") : contains VERY IMPORTANT INFORMATIONS

If there are any SQL reserved words NOT set to level 1 in the list DMC uses then the sql server might report this as an ERROR and DMC will LOG them at the BOTTOM of this "include" file

------------------------------

ERRORS on (missing) SQL Reserved Words in the ODBC level LIST - You will need to ADD them (see docs)

Table [sql_eWORDER] Error Reported [SQL Class Error :

90 - Error File System

37000 - Incorrect syntax near the keyword 'LineNo'.]

------------------------------

This example informs you in the Table named eWORDER (renamed as sql_eWORDER) there is a column named as "LineNo"

You will need to open the SQL reserved words list and set to level ONE this word and reparse your DCT.

The DCTX generated from DMC will let you create a new DCT in Clarion7 or Clarion8

This DCT will then need to be exported to TXD from c7 or c8

Select "All Files" and change the EXTENSION to TXD

This exported from c7 or c8 TXD needs then to be made Clarion6 compliant :

1.	Open DMC and select Port to SQL task from the navigation Panel

2.	Select again your original DCTX

3.	Select the "regenerate" option

4.	This will allow you to access this screen

5.	Click on "Select your TXD File (c7 -> c6)" to parse it and make it clarion 6 compatible.

6.	Click on proceed

This will generate for you a Clarion6 compliant TXD you can import in a NEW DCT in c6.

(of course if you do not have direct access to c7 or c8 we will do this conversion for you)

A DMC CREATED FOLDER with all your Files and SQL scripts contains VERY IMPORTANT TABLES - DO NOT DELETE

You can edit copy them but NEVER DELETE or MODIFY them as this could BREAK all the Step's work!

DCTX generated File : As you defined a Destination Folder, DMC will copy there all generated Files.

(DMC will close and reopen automatically after this)