|
Attribute keyword used in SQL statement
|
Description
|
Value
|
|
PRO_DESCRIPTION
|
Equivalent to ABL DESCRIPTION.
|
Arbitrary character string
|
|
PRO_DUMP_NAME
|
Equivalent to ABL DUMP-NAME.
|
Arbitrary character string
|
|
PRO_FROZEN
|
Equivalent to ABL FROZEN.
Note: OpenEdge SQL honors the value set here and does not allow modification of a frozen table using the ALTER TABLE, CREATE INDEX, CREATE PRO_WORD INDEX, DROP INDEX, or DROP TABLE commands.
However, the frozen attribute may be set to 'N' to unfreeze a frozen table. For example: ALTER TABLE Customer SET PRO_FROZEN 'N';
|
'Y''y''N''n'
|
|
PRO_HIDDEN
|
Indicates whether the table is shown in ABL tools and reports.
|
'Y''y''N''n'
|
|
PRO_LABEL
|
Equivalent to ABL LABEL.
|
Arbitrary character string
|
|
PRO_VALEXP
|
Indicates an ABL validation expression.
|
Arbitrary character string
|
|
PRO_VALMSG
|
Indicates an ABL validation message.
|
Arbitrary character string
|
|
PRO_SA_VALMS
|
Indicates an ABL string attributes validation message.
|
Arbitrary character string
|
|
PRO_SA_LABEL
|
IndThe following tableicates an ABL table label.
|
Arbitrary character string
|
|
PRO_DEFAULT_INDEX
|
Determines default data-access index for a table.
|
Name of an index or table
|
|
Attribute keyword used in SQL statement
|
Description
|
Value
|
|
PRO_COL_LABEL
|
Equivalent to ABL COL-LABEL
|
Free-form text
|
|
PRO_DATA_TYPE
|
Equivalent to ABL DATA-TYPE
Note: This attribute should be used only while converting INTEGER to INT64.
|
-
|
|
PRO_DESCRIPTION
|
Equivalent to ABL DESCRIPTION
|
Free-form text
|
|
PRO_FORMAT
|
Equivalent to ABL FORMAT
|
ABL format string
|
|
PRO_HELP
|
Indicates a ABL help message
|
Free-form text
|
|
PRO_LABEL
|
Indicates ABL label
|
Free-form text
|
|
PRO_RPOS
|
Indicates ABL relative record position
|
Positive integer
|
|
PRO_SQL_WIDTH
|
Indicates SQL width
Note: This attribute works only with CHARACTER and Binary columns
|
Positive integer
|
|
PRO_VIEW_AS
|
Equivalent to ABL VIEW-AS
|
Free-form text
|
|
PRO_ORDER
|
Equivalent to ABL ORDER
|
Integer value
|
|
PRO_VALEXP
|
Indicates ABL validation expression
|
Free-form text
|
|
PRO_VALMSG
|
Indicates ABL validation message
|
Free-form text
|
|
PRO_SA_LABEL
|
Indicates ABL string attribute column label
|
Arbitrary character string
|
|
PRO_SA_COL_LABEL
|
Indicates ABL string attribute column label
|
Arbitrary character string
|
|
PRO_SA_FORMAT
|
Indicates ABL string attribute column label
|
Arbitrary character string
|
|
PRO_SA_INITIAL
|
Indicates ABL string attribute column label
|
Arbitrary character string
|
|
PRO_SA_HELP
|
Indicates ABL string attribute column label
|
Arbitrary character string
|
|
PRO_SA_VALMSG
|
Indicates ABL string attribute column label
|
Arbitrary character string
|
|
DEFAULT
Note: DEFAULT is a common attribute of both SQL and ABL.
|
Indicates the default value for a column.
|
A literal value whose type is compatible with the type of the column
|
|
PRO_CASE_SENSITIVE
|
Indicates case-sensitivity
|
'Y''y''N''n'
|
|
PRO_LOB_SIZE_TEXT
|
The maximum size of a BLOB or CLOB column described as a string
|
Free-form text. For example: '32M'
|
|
Attribute keyword used in SQL statement
|
Description
|
Value
|
|
PRO_ACTIVE
|
Changes the index's status from active to inactive. This action must be performed offline.
|
'n'
|
|
PRO_DESCRIPTION
|
Equivalent to ABL DESCRIPTION.
|
Free-form text
|