Click on the "Proceed with task" button to define the Level of SQL Normalizations to apply :
This STEP is to allow you selecting the LEVEL of settings you want to use.
The SQL normalization settings and Dictionary Cleaning Options are available as either :
1. Predefined with GUID (add a GUID Column and a Primary Key using this NEW Column to tables with NO primary key)
2. Predefined with Identity (add an IDENTITY Column and a Primary Key using this NEW Column to tables with NO primary key)
3. Predefined Minimal (do NOT add any Column or Key - do NOT rename KEYS etc ...)
4. Advanced (define ALL settings individually - recommended AFTER trying out DEFAULT levels)
(details of these settings are all available on this comparison page)
IMPORTANT : You need to select #1 - #2 or #3 BEFORE selecting the "Advanced" level to as to "define" the base level on which to apply the "Advanced"!
We recommend using the predefined "with GUID" or "with IDENTITY" levels to start with.
Select the Casing you would like to apply : lowercase - UPPERCASE or CamelBackCasing (as is with NO changes)
(ie FireBird requires UPPERCASING and we recommend lowercase for PostGre SQL)
Define to use or not External Names in your Dictionary
NOTE : If you select to use External Names, please be reminded that in CODE you will need to remember TWO SETS of column or key names - clarion DCT for Clarion code and SQL (external names) for any SQL code!
Define the Destination Folder for OUTPUT Files
IMPORTANT : (all generated files will be COPIED to this folder for you to WORK in Clarion from these files)
Click on the "Next" button to see a "sum up" of what will be performed for you
Click on the "Proceed" button to start parsing your DCTX
NOTE : You can SAVE and RESTORE all these settings