Chapter 12 DBMS-Specific Features


IBM DB2 extended attributes

The following extended attributes are defined by default in the IBM DB2 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

 


Copyright (C) 2008. Sybase Inc. All rights reserved.