SQLRecord field level properties

The SQLRecord field level properties specify characteristics that are meaningful when a field is defined as part of a record with a SQLRecord stereotype (see Stereotypes). None of the SQL field properties is required; default values are available for all of them.

Table 1. SQL field properties
Property Description
asBytes Indicates that the property contains binary or bit data, not character text.
column Refers to the name of the SQL database table column that is associated with the field. The default is the name of the field.
isReadOnly Indicates whether the field and related column are omitted from the default SQL statements that write to the database or include a FOR UPDATE OF clause.
isSQLNullable Indicates whether the SQL field can be set to null, as when the table column associated with the field can be set to NULL.
maxLen Specifies the maximum length of field text that is written to the database column.
persistent Indicates whether the field is included in the implicit SQL statements generated for the SQL record.
sqlDataCode Identifies the SQL data type that is associated with the record field.
sqlVariableLen Indicates whether trailing blanks and nulls in a character field are truncated before the EGL runtime writes the data to an SQL database.

Feedback