Setting preferences for SQL retrieve

At EGL declaration time, you can use the SQL retrieve feature to create an SQL record from the columns of an SQL table. For an overview, see SQL support.

To set preferences for the SQL retrieve feature, do as follows:

1. Click Window > Preferences, then expand EGL and click SQL Retrieve

2. Specify rules for naming each structure item that is created by the SQL retrieve feature:
   1. To specify the case of the structure item name, click one of the following radio buttons:
      • Do not change case (the default) means that the case of the structure item name is the same as the case of the related table column name

      • Change to lower case means that the structure item name is a lower-case version of the table column name

      • Change to lower case and capitalize first letter after underscore also means that the structure item name is a lower-case version of the table column name, except that a letter in the structure item name is rendered in uppercase if, in the table column name, the letter immediately follows an underscore

   2. To specify how the underscores in the table column name are reflected in the structure item name, click one of the following radio buttons:
      • Do not change underscores (the default) means that underscores in the table column name are included in the structure item name

      • Remove underscores means that underscores in the table column name are not included in the structure item name

      • Change underscores to hyphens means that underscores in the table column name are rendered as hyphens in the structure item name

3. If you intend to retrieve data from a table that is part of an Informix system schema, clear the check box for Exclude system schemas. (In this case, "Informix" is the table owner.) In all other cases, select the check box to improve the performance of the SQL retrieve feature.

   The check box is selected by default.

Related concepts
SQL support

Related tasks
Retrieving SQL table data
Setting EGL preferences
Setting preferences for SQL database connections

Related reference
Informix and EGL