|
SQL Reserved Words |
  
|
|
SQL Reserved Words |
|
This module is used to store all SQL reserved words NOT to be used when you build Tables
You can add edit or delete any of them to accommodate your favorite version of SQL or desired company standards.
You have TWO LEVELS : 1 ie compulsory (used by DMC during cloning tasks) and 2 optional
You can "move" any word from the level 2 to the level 1 (applied and used by DMC during cloning tasks) by changing in EIP mode the level.
It is NOT possible for you to change the level the other way round (from 1 to 2) except if originally the word was level 2.
IMPORTANT : we had frequent feedback from clients that DMC could NOT transfer data into this or that SQL table. It always typically a problem of reserved words used for Tables, Columns or Keys. So when you build your tables keep this in mind and use any technique you prefer so as to avoid this situation (example a column called LENGTH will not allow ODBC drivers on some SQL server to properly use the Table, so rename it to PRD_LENGTH for the Products Table and SIZ_LENGTH etc ...)
TIP: For Clarion users, you can Start the process to Port your Application to SQL and DMC will tell you all the places where your Dictionary is using a Reserved Word as a Table, Column or Key name. Even if you don't plan to convert to SQL right now, it's a good idea to see where you may have a conflict in the future.