SQL Compatibility

Use this utility when preparing an application dictionary for use with a SQL database. This utility examines a dictionary for the following conditions, which would prevent the application from working properly with SQL:

• SQL limits that have been exceeded. The following limits are tested: the number of fields in the table definition, the record size of each table, the number of keys for each table and the number of segments in each key.
• Table fields that don’t have physical names.
• Table field physical names that are SQL reserved words.
• Table database types that aren’t SQL or Default.
• Tables for which no index is generated.

The SQL Compatibility utility prints the incompatibility information as a report. It can also make the necessary changes to the application dictionary to make it compatible for use with SQL.

To check the SQL compatibility of a dictionary, open an editable dictionary, then choose SQL Compatibility from the Utilities menu to open the SQL Compatibility window.

1. Specify the compatibility categories to examine.

Mark the check boxes in the Category group to specify the incompatibilities to look for.

Field Physical Names   Mark this option to find out which table fields don’t have physical names.

Reserved Words   Mark this option to examine table fields to find out whether the physical names are SQL reserved words.

Table Database Types   Mark this option to examine the database type of each table in the application dictionary.

Create Index   Mark this option to examine the SQL key options for each key of every table in the application dictionary.

2. Generate a compatibility report or make the dictionary compatible.

Click Check to generate a report listing the SQL limits exceeded and any incompatibilities for the categories you specified. Click Make Compatible to make changes to the application dictionary that will remove the SQL incompatibilities. When you click Make Compatible, a report will also be generated that lists the changes made to the application dictionary.

When you click Make Compatible, the following changes will be made to remove incompatibilities:

• If you marked the Field Physical Names option, any table field that doesn’t have a physical name will be given one. The physical name will be based upon the field name.
• If you marked the Reserved Words option, any table field physical names that are SQL reserved words will have an integer appended to the name. The physical name will be truncated, if necessary.
• If you marked the Table Database Types option, any tables that don’t have SQL or Default as their database type will be changed to have Default as the database type.
• The Create Index SQL key option will be marked for each key of every table in the dictionary.

The Unique SQL key option will also be marked appropriately
for each key, based upon current setting of the Duplicates key option. If Duplicates is not marked, the Unique key option will
be marked. If Duplicates is marked, the Unique key option will be unmarked.

Documentation Feedback

---