The Auto Create push button is part of the Link Variables dialog box.
Use Auto Create to automatically create EASEL variables of the appropriate types for the selected columns.
The following suffixes are appended to the column name:
_SV |
for string variable |
_IV |
for integer variable |
_FV |
for float variable |
_NIV |
for null indicator variable |
You cannot use Auto Create to link EASEL variables to computed columns. To do this, you can either:
•Use the New push button to create a new variable.
•Link the computed column to a predefined variable in the variable file.
The following characters are not permitted in EASEL variable names:
@ (at sign)
# (pound sign)
$ (dollar sign)
If these characters appear in a column name in a SQL statement, DB/Assist will strip them out when it generates variable names for the Auto Create function.
