Data Warehouse Center Application Integration Guide

TABLES object

This object contains metadata about a warehouse source table, segment, or file, or a target table. It is associated with a DATABASE object (see DATABASE object).

Properties

Table 57 provides information about the properties of the TABLES object.

Table 57. Properties of the TABLES object

Tag language property name Description Allowed values
NAME The name of the table, file, or IMS segment.
The table name includes the high-level qualifier, schema or collection, such as IWH.TABLE1.
The combination of the database name and the table name is unique.
This property is the fully qualified path and file name for a file.
A text string, up to 80 bytes in length.
SHRTDESC The short description of the file or segment. A text string, up to 200 bytes in length.
LONGDESC The long description of the table. A text string, up to 32700 bytes in length.
DBNAME The business name of the source that contains this table or file. A text string, up to 80 bytes in length.
OWNER The owner, high-level qualifier, or collection of the table.
This property is null for files and IMS segments.
A text string, up to 15 bytes in length.
TABLES The physical table, file, or segment name as defined to the database manager or file system.
For files and IMS segments, this value is the same as the value of NAME.
A text string, up to 80 bytes in length.
TBLISBIN A flag that specifies the file transfer mode for Flat File LAN files. One of the following values:

Y
The file transfer mode is binary.
N
The file transfer mode is ASCII.

TBLNAMESP The name of the DB2 table space. A text string, up to 90 bytes in length.
TBLFTYPE For files, the type of the file. One of the following values:

1
Fixed
2
Comma
3
Tab
4
Character

TBLL1NAM A flag that specifies whether the first row of the file contains column names. One of the following values:

Y
The first row of the file contains column names.
N
The first row of the file contains data.

CHARDELM For files, the character separator if the file type is character. A text string that is 1 byte in length.
CREATYPE The method used to define the table in the Data Warehouse Center. One of the following values:

1
The table was defined manually.
2
The table definition was imported from the database manager.
3
The table definition was imported from the Information Catalog Manager.
4
The table was created by the Data Warehouse Center for a step when the step was promoted to test mode.

TABALIAS A flag that specifies whether the table has an alias. One of the following values:

Y
The table has an alias.
N
The table does not have an alias.

IWHCRTAR A flag that specifies whether the target table is created by the Data Warehouse Center. One of the following values:

Y
The target table is created by the Data Warehouse Center.
N
The target table is not created by the Data Warehouse Center.

IWHGRANT A flag that specifies whether GRANT TO PUBLIC is enabled for the table. One of the following values:

Y
GRANT TO PUBLIC is enabled for the table.
N
GRANT TO PUBLIC is been enabled for the table.

IWHDRATN The warehouse target duration, either transient or persistent. One of the following values:

Y
The table is persistent.
N
The table is transient.

IWHMAXED The maximum number of editions of the table. A numeric value.
IWHCREGN A flag that specifies whether the create statement is automatically generated. One of the following values:

Y
The Create statement is automatically generated.
N
The Create statement is not automatically generated.

IWHCRERU The create statement for the table. A text string, up to 32,700 bytes in length.
IDSFACT A flag that specifies whether the table is used as a fact table. One of the following values:

Y
The table is used as a fact table.
N
The table is not used as a fact table.

CDSSCHEMA The table schema for replication. A text string, up to 128 bytes in length.
CDTABNAM The table name for replication. A text string, up to 128 bytes in length.
BEFORIMG The replication before-image prefix. A text string, up to 4 bytes in length.
IDSREPL A flag that specifies whether the table is used for replication. One of the following values:

Y
The table is used for replication.
N
The table is not used for replication.

NAMINDEX The DB2 table name index. A text string, up to 90 bytes in length.
PARTTBSP A flag that specifies whether the table is in a partitioned table space. One of the following values:

Y
The table is in a partitioned table space.
N
The table is not in a partitioned table space.

DBNAM390 The System 390 database name. A text string, up to 8 bytes in length.

Tag language property name	Description	Allowed values
NAME	The name of the table, file, or IMS segment. The table name includes the high-level qualifier, schema or collection, such as IWH.TABLE1. The combination of the database name and the table name is unique. This property is the fully qualified path and file name for a file.	A text string, up to 80 bytes in length.
SHRTDESC	The short description of the file or segment.	A text string, up to 200 bytes in length.
LONGDESC	The long description of the table.	A text string, up to 32700 bytes in length.
DBNAME	The business name of the source that contains this table or file.	A text string, up to 80 bytes in length.
OWNER	The owner, high-level qualifier, or collection of the table. This property is null for files and IMS segments.	A text string, up to 15 bytes in length.
TABLES	The physical table, file, or segment name as defined to the database manager or file system. For files and IMS segments, this value is the same as the value of NAME.	A text string, up to 80 bytes in length.
TBLISBIN	A flag that specifies the file transfer mode for Flat File LAN files.	One of the following values: Y The file transfer mode is binary. N The file transfer mode is ASCII.
TBLNAMESP	The name of the DB2 table space.	A text string, up to 90 bytes in length.
TBLFTYPE	For files, the type of the file.	One of the following values: 1 Fixed 2 Comma 3 Tab 4 Character
TBLL1NAM	A flag that specifies whether the first row of the file contains column names.	One of the following values: Y The first row of the file contains column names. N The first row of the file contains data.
CHARDELM	For files, the character separator if the file type is character.	A text string that is 1 byte in length.
CREATYPE	The method used to define the table in the Data Warehouse Center.	One of the following values: 1 The table was defined manually. 2 The table definition was imported from the database manager. 3 The table definition was imported from the Information Catalog Manager. 4 The table was created by the Data Warehouse Center for a step when the step was promoted to test mode.
TABALIAS	A flag that specifies whether the table has an alias.	One of the following values: Y The table has an alias. N The table does not have an alias.
IWHCRTAR	A flag that specifies whether the target table is created by the Data Warehouse Center.	One of the following values: Y The target table is created by the Data Warehouse Center. N The target table is not created by the Data Warehouse Center.
IWHGRANT	A flag that specifies whether GRANT TO PUBLIC is enabled for the table.	One of the following values: Y GRANT TO PUBLIC is enabled for the table. N GRANT TO PUBLIC is been enabled for the table.
IWHDRATN	The warehouse target duration, either transient or persistent.	One of the following values: Y The table is persistent. N The table is transient.
IWHMAXED	The maximum number of editions of the table.	A numeric value.
IWHCREGN	A flag that specifies whether the create statement is automatically generated.	One of the following values: Y The Create statement is automatically generated. N The Create statement is not automatically generated.
IWHCRERU	The create statement for the table.	A text string, up to 32,700 bytes in length.
IDSFACT	A flag that specifies whether the table is used as a fact table.	One of the following values: Y The table is used as a fact table. N The table is not used as a fact table.
CDSSCHEMA	The table schema for replication.	A text string, up to 128 bytes in length.
CDTABNAM	The table name for replication.	A text string, up to 128 bytes in length.
BEFORIMG	The replication before-image prefix.	A text string, up to 4 bytes in length.
IDSREPL	A flag that specifies whether the table is used for replication.	One of the following values: Y The table is used for replication. N The table is not used for replication.
NAMINDEX	The DB2 table name index.	A text string, up to 90 bytes in length.
PARTTBSP	A flag that specifies whether the table is in a partitioned table space.	One of the following values: Y The table is in a partitioned table space. N The table is not in a partitioned table space.
DBNAM390	The System 390 database name.	A text string, up to 8 bytes in length.

Figure 16 shows an example of a TABLES object instance for a relational table.

Figure 16. TABLES object instance for a relational table

:COMMENT. Begin TABLES Instance :COMMENT. :ACTION.OBJINST(MERGE) :OBJECT.TYPE(TABLES) :INSTANCE. NAME(IWH.ATOMICED) DBNAME(iwhtar) OWNER(IWH) TABLES(ATOMICED) TBLISBIN(N) TBLFTYPE(0) TBLL1NAM(N) CREATYPE(4) :COMMENT. :COMMENT. End TABLES Instance

Figure 17 shows an example of a TABLES object instance for a file.

Figure 17. TABLES object instance for a file

:COMMENT. Begin TABLES Instance :COMMENT. :ACTION.OBJINST(MERGE) :OBJECT.TYPE(TABLES) :INSTANCE. NAME(d:\iwhdemo\outcusti.txt) SHRTDESC(File containing operational data for Institutions Customers) DBNAME(TBC Operations) OWNER() TABLES(d:\iwhdemo\outcusti.txt) TBLISBIN(Y) TBLFTYPE(3) TBLL1NAM(N) CREATYPE(1) :COMMENT. :COMMENT. End TABLES Instance

Relationships

Table 58 lists the relationships in which the TABLES object participates and that are useful for partner applications. The Source column and the Target column indicate how many times the source object or target object of the relationship can participate in the relationship.

Table 58. Relationships in which the TABLES object participates

Source Source tag language object type Relation type Target Target tag language object type Description
1 DATABASE CONTAIN M TABLES Database or file system with which this table or file is associated.
1 TABLE CONTAIN M COLUMN Columns associated with this table.

Source	Source tag language object type	Relation type	Target	Target tag language object type	Description
1	DATABASE	CONTAIN	M	TABLES	Database or file system with which this table or file is associated.
1	TABLE	CONTAIN	M	COLUMN	Columns associated with this table.

Figure 18 shows an example of a relationship between a TABLES object instance and a DATABASE object instance.

Figure 18. Linking TABLES object instance to DATABASE object instance

:COMMENT. Relation: DATABASE to TABLES :COMMENT. :ACTION.RELATION(ADD) :RELTYPE.TYPE(CONTAIN) SOURCETYPE(DATABASE) TARGETYPE(TABLES) :INSTANCE. SOURCEKEY(NAME(TBC Operations) DBNAME() ) TARGETKEY(DBNAME(TBC Operations) OWNER() TABLES(d:\iwhdemo\outcusti.txt) )

Figure 19 shows an example of a relationship between a TABLES object instance and a COLUMN object instance.

Figure 19. Linking TABLES object instance to COLUMN object instance

:COMMENT. Relation: TABLES to COLUMN :COMMENT. :ACTION.RELATION(ADD) :RELTYPE.TYPE(CONTAIN) SOURCETYPE(TABLES) TARGETYPE(COLUMN) :INSTANCE. SOURCEKEY(DBNAME(TBC Operations) OWNER() TABLES(d:\iwhdemo\outcusti.txt) ) TARGETKEY(DBNAME(TBC Operations) OWNER() TABLES(d:\iwhdemo\outcusti.txt) COLUMNS(Zipcode) )

[ Top of Page | Previous Page | Next Page ]