The following table lists the equivalent of ABL keywords to use while accessing ABL table attribute details with OpenEdge SQL statements.

Table 1. ABL table attributes used in OpenEdge SQL statements
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

The following table lists the keywords to use when setting ABL column attributes with OpenEdge SQL statements.

Table 2. ABL column attributes used in OpenEdge SQL statements
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'

The following table lists the keywords to use when setting ABL index attributes with OpenEdge SQL statements.

Table 3. ABL index attributes used in OpenEdge SQL statements
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