Attributes

The following data type attributes are added for SQL/MX 3.5.

Attribute	Setting
VARCHAR_PARAM_DEFAULT_SIZE	Depending on the context, untyped parameters might be converted to the VARCHAR type during compilation of a query. This CQD allows you to change the default length. Allowable values: 1 to 32768. The default is 255 characters.
NUMBER_DEFAULT_PRECISION	This CQD allows the user to change the default precision for NUMBER data type. Allowable values: 1 to 128. The default value is 18.
NUMBER_DEFAULT_SCALE	This CQD allows the user to change the default scale for NUMBER data type. Allowable values: 0 to 128. The default value is 6.

Attribute

Setting

VARCHAR_PARAM_DEFAULT_SIZE

Depending on the context, untyped parameters might be converted to the VARCHAR type during compilation of a query. This CQD allows you to change the default length.

Allowable values: 1 to 32768.

The default is 255 characters.

NUMBER_DEFAULT_PRECISION

This CQD allows the user to change the default precision for NUMBER data type.

Allowable values: 1 to 128.

The default value is 18.

NUMBER_DEFAULT_SCALE

This CQD allows the user to change the default scale for NUMBER data type.

Allowable values: 0 to 128.

The default value is 6.

The following table size attributes are added in SQL/MX 3.5.

Attribute	Setting
POS_PRI_EXT_SIZE	Specifies the primary extent size. From SQL/MX Release 3.5 onwards, the primary extent size is determined from table sizes or from this CQD only. The default value is 16.
POS_SEC_EXT_SIZE	Specifies the secondary extent size. From SQL/MX Release 3.5 onwards, the secondary extent size is determined from table sizes or from this CQD only. The default value is 64.
POS_MAX_EXT	Specifies the default MAXEXTENTS value. From SQL/MX Release 3.5 onwards, the MAXEXTENTS size is determined from table sizes or from this CQD only. The default value is 160.

Attribute

Setting

POS_PRI_EXT_SIZE

Specifies the primary extent size. From SQL/MX Release 3.5 onwards, the primary extent size is determined from table sizes or from this CQD only.

The default value is 16.

POS_SEC_EXT_SIZE

Specifies the secondary extent size. From SQL/MX Release 3.5 onwards, the secondary extent size is determined from table sizes or from this CQD only.

The default value is 64.

POS_MAX_EXT

Specifies the default MAXEXTENTS value. From SQL/MX Release 3.5 onwards, the MAXEXTENTS size is determined from table sizes or from this CQD only.

The default value is 160.

The following attributes are added for External Username behavior in SQL/MX 3.5.

Attribute	Setting
EXTERNAL_NAME_CASESENSITIVE	Specifies whether the External Username is case-sensitive or not. This is a read-only CQD. Allowable values: ON, OFF, and NONE. The default value is NONE. When set to ON, an External Username is treated like other SQL identifiers: A regular identifier is not case-sensitive and will be upshifted on entry, a delimited identifier is case-sensitive and will not be upshifted. When set to OFF, an External Username is always upshifted on entry. When set to NONE, External Username cannot be created.
EXTERNAL_NAME_DISPLAY	Specifies how username is displayed. In the multi-tenant environment, the External Username is always displayed. Allowable values: ON, and OFF The default value is OFF. When set to ON, error messages, SHOWDDL, and SHOWLABEL will display the External Username if it exists, otherwise the Guardian username. When set to OFF, only Guardian username will be displayed.

Attribute

Setting

EXTERNAL_NAME_CASESENSITIVE

Specifies whether the External Username is case-sensitive or not. This is a read-only CQD.

Allowable values: ON, OFF, and NONE.

The default value is NONE.

When set to ON, an External Username is treated like other SQL identifiers: A regular identifier is not case-sensitive and will be upshifted on entry, a delimited identifier is case-sensitive and will not be upshifted.

When set to OFF, an External Username is always upshifted on entry.

When set to NONE, External Username cannot be created.

EXTERNAL_NAME_DISPLAY

Specifies how username is displayed. In the multi-tenant environment, the External Username is always displayed.

Allowable values: ON, and OFF

The default value is OFF.

When set to ON, error messages, SHOWDDL, and SHOWLABEL will display the External Username if it exists, otherwise the Guardian username.

When set to OFF, only Guardian username will be displayed.