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:
- Click Window > Preferences, then expand EGL and click SQL
Retrieve
- Specify rules for creating each structure item that is created by the
SQL retrieve feature:
- To specify the EGL type to use when creating a structure item from an
SQL character data type, click one of the following radio buttons:
- Use EGL type string (the default) maps SQL char
data types to EGL string data types
- Use EGL type limited-length string maps SQL
char data types to EGL limited-length string data types
- Use EGL type char maps SQL char data types to
EGL char data types
- Use EGL type mbChar maps SQL char data types
to EGL mbChar data types
- Use EGL type Unicode maps SQL char data types
to EGL Unicode data types
- 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
- 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
- If you want new SQL records to have the key item property set, select
the Retrieve primary key information from the system catalog check
box.