IBM DB2 Extended Attributes for z/OS

The following extended attributes are defined by default in the IBM DB2 for z/OS DBMS.

Column

The following extended attributes are available on the DB2 tab:

Name

Description

Field procedure name

Defines the procedure that will be used as generator/cryptor of values.

Scripting name: ExtFieldProcName

Character subtype

[up to v6.x] Specifies a subtype for a character string column (column with a CHAR,VARCHAR,or LONG VARCHAR data type). The subtype can proceed from the list defined in extended attribute type T_ForData.

Scripting name: ExtData

Generated value

[v7.x and higher] Indicates that DB2 generates values for the column using the computed column function. If you select Always, the server will send an error message if you try to type a value in the column. If you select By Default, the server uses the computed column value or the value typed for the column.

Scripting name: ExtGeneratedAs

Character subtype

[v7.x and higher] Specifies a subtype for a character string column.

Scripting name: ExtSubtypeData

Domain

The following extended attributes are available on the DB2 tab:

Name

Description

Character Subtype

[v6.x and higher] Specifies a subtype for a character string column.

Scripting name: ExtSubtypeData