Data Warehouse Center Application Integration Guide

Predefined object type models

The Information Catalog Manager predefined object types participate in the six data models shown in Figures Figure 27 through Figure 32.

Figure 27 shows the object types that participate in the relational model.

Figure 27. Relational model and the predefined object types

Chart showing how certain object types relate to each other in the relational model

Figure 28 shows the object types that participate in the hierarchical models.

Figure 28. Hierarchical models and the predefined object types

Chart showing how certain object types relate to each other within the hierarchical models

Figure 29 shows the object types that participate in the file models.

Figure 29. File models and the predefined object types

Chart showing how certain object types relate to each other within the file models

Figure 30 shows the object types that participate in the multi-dimensional (OLAP) model.

Figure 30. Multi-dimensional model and the predefined object types

Chart showing how certain object types relate to each other in the multi-dimensional model

Figure 31 shows the object types that participates in the transformation models.

Figure 31. Transformation model and the predefined object types

Chart showing how certain object types relate to each other within the transformation models

Figure 32 shows the object types that participates in the subject area model.

Figure 32. Subject area model and the predefined object types

Chart showing how certain object types relate to each other in the subject area model

Predefined object type descriptions

Sample Information Catalog Manager object types are organized by category and defined in the tables that start on page "Application data".

Each table lists the properties for that object type. Each property is described in terms of its property specifications. A property's specifications govern the value that you can give that property when creating or updating an object of that object type.

The property specifications are:
EXTNAME The name of the property; for example, Business Name.
DT The data type of the property's value; for example, CHAR or VARCHAR.
DL The length (maximum length for VARCHAR or LONG VARCHAR data types) of the value for the property.
SHRTNAME The name used to identify the property within the Information Catalog Manager data store.
NULLS
R
A value for the property is required; value for NULLS in the tag language is N.
O
A value for the property is optional; value for NULLS in the tag language is Y.
S
A value generated by the Information Catalog Manager that indicates that provides a value for the property when any object is created. You cannot specify this value.

UUISEQ If the property is part of the UUI, then this number indicates its position within the UUI.

MDIS mappings

Tables that describe Information Catalog Manager object type properties begin on page "Application data". For each object type that conforms to the Metadata Interchange Specification (MDIS), the MDIS equivalent for each property appears in the column titled Maps to MDIS name.

  1. Find the table for the object type you are exporting.
  2. Find the MDIS name in the Maps to MDIS name column.
  3. Find the equivalent Information Catalog Manager names in the Property name and Property short name columns.

Each property described in the following object type property tables corresponds to a column with the same property short name in the Information Catalog Manager DB2 storage table XXX.object_type_name, where object_type_name is the name of the object type described in the table. If the property data type is LONG VARCHAR, the property corresponds to a row in the Information Catalog Manager DB2 storage table FLG.OVERDESC.

Grouping category

The Grouping category contains the following object types:

Application data

Used by the Information Catalog Manager for some MDIS metadata exchanges. Objects of this object type might appear in your information catalog, but you do notuse this object type to create objects.

The tag language for defining this object type is in the file FLGNYAPL.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.APPLDATA. For more information on table names, see MDIS mappings.

Table 78 provides information about the properties of the Application data object type.

Table 78. Properties of the Application data object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME O
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Source object identifier CHAR 16 FLGID R 1
Application data field 0 LONG VARCHAR 32700 APPLDAT0 O
Application data field 1 LONG VARCHAR 32700 APPLDAT1 O
Application data field 2 LONG VARCHAR 32700 APPLDAT2 O
Application data field 3 LONG VARCHAR 32700 APPLDAT3 O
Application data field 4 LONG VARCHAR 32700 APPLDAT4 O
Application data field 5 LONG VARCHAR 32700 APPLDAT5 O
Application data field 6 LONG VARCHAR 32700 APPLDAT6 O
Application data field 7 LONG VARCHAR 32700 APPLDAT7 O
Application data field 8 LONG VARCHAR 32700 APPLDAT8 O
Application data field 9 LONG VARCHAR 32700 APPLDAT9 O
Timestamp source definition created CHAR 26 CRTTIME O
Timestamp source definition last changed CHAR 26 SRCDATCF O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Business subject areas

Represents logical groupings of objects.

The tag language for defining this object type is in the file FLGNYINF.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.INFOGRPS. For more information on table names, see MDIS mappings.

Table 79 provides information about the properties of the Business subject areas object type.

Table 79. Properties of the Business subject areas object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Filename VARCHAR 254 FILENAME O
URL to access data VARCHAR 254 URL O
For more information . . . VARCHAR 80 CONTACT O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Columns or fields

Represents columns within a relational table, fields within a file, or fields within an IMS segment.

The tag language for defining this object type is in the file FLGNYCOL.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.COLUMNS. For more information on table names, see MDIS mappings.

Table 80 provides information about the properties of the Columns or fields object type.

Table 80. Properties of the Columns or fields object type
The MDIS name for this object type is Element.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
ElementLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
Catalog remarks VARCHAR 254 REMARKS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Column or field last refreshed CHAR 26 FRESHDAT O
ElementLastRefreshDate
Data type of column or field CHAR 30 DATATYPE O
ElementDataType
Length of column or field CHAR 20 LENGTH O
ElementLength
Scale of column or field CHAR 5 SCALE O
ApplicationData
Precision of column or field CHAR 5 PRECDIG O
ElementPrecision
Can column or field be null CHAR 1 NULLS O
ElementNulls
Column or field ordinality CHAR 5 ORDINAL O
ElementOrdinality
Column or field position CHAR 5 POSNO O
ElementPosition
Byte offset of column or field from start CHAR 10 STARTPOS O
ApplicationData
Is column or field part of a key CHAR 1 ISKEY O
ApplicationData
Is column or field a unique key CHAR 1 UNIQKEY O
ApplicationData
Position of column or field within key CHAR 5 KEYPOSNO O
ElementKeyPosition
Database host server name VARCHAR 80 SERVER O
ServerName
Database or subsystem name VARCHAR 80 DBNAME R 1 DatabaseName
Table owner VARCHAR 80 OWNER R 2 OwnerName
Table name VARCHAR 80 TABLES R 3 RecordName
Column or field name VARCHAR 254 COLUMNS R 4 ElementName
Filename VARCHAR 254 FILENAME R 5 ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
Containing dimension VARCHAR 80 DIMENSION O
DimensionName
Is data a before or after image, or computed CHAR 50 COLIMAGE O
ApplicationData
Source column or field name or expression used to populate column VARCHAR 254 COLEXPR O
ApplicationData
String used to represent null values VARCHAR 30 IDSNREP O
ApplicationData
Resolution of dates CHAR 1 IDSRES O
ApplicationData
Is data text CHAR 1 ISTEXT O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Databases

Represents relational databases.

The tag language for defining this object type is in the file FLGNYDAT.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.DATABAS. For more information on table names, see MDIS mappings.

Table 81 provides information about the properties of the Databases object type.

Table 81. Properties of the Databases object type
The MDIS name for this object type is Database.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
DatabaseLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database owner VARCHAR 80 OWNER O
OwnerName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database server type VARCHAR 80 SRVRTYPE O
ServerType
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Database type VARCHAR 80 DBTYPE R 3 DatabaseType
Database extended type VARCHAR 40 DBETYPE O
DatabaseExtendedType
Database status VARCHAR 80 DBSTAT O
DatabaseStatus
Database location VARCHAR 80 LOCATION O
ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
System code page VARCHAR 10 CODEPAGE O
ApplicationData
Agent type VARCHAR 80 AGENTYPE O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Dimensions within a multidimensional database

Represents dimensions within a multidimensional database. A dimension is comprised of members.

The tag language for defining this object type is in the file FLGNYDIM.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.DIMENSION. For more information on table names, see MDIS mappings.

Table 82 provides information about the properties of the dimensions within a multidimensional database object type.

Table 82. Properties of the Dimensions within a multidimensional database object type
The MDIS name for this object type is Dimension.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
DimensionLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database last refreshed CHAR 26 FRESHDAT O
ApplicationData
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Using application name VARCHAR 80 APPLNAME R 3 ApplicationData
Dimension owner VARCHAR 80 OWNER O
OwnerName
Dimension name VARCHAR 80 DIMENSON R 4 DimensionName
Dimension class or type VARCHAR 80 TYPE O
DimensionType
Total member count CHAR 10 TOTALCNT O
DimensionCount
Level count CHAR 10 LEVELCNT O
DimensionLevelCount
Application-specific information VARCHAR 512 APPLDATA O
ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

DWC Process

Represents a process in the Data Warehouse Center.

The tag language for defining this object type is in the file FLGNYINF.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.DWCPROC. For more information on table names, see MDIS mappings.

Table 83 provides information about the properties of the Business subject areas object type.

Table 83. Properties of the DWC Process object type
Property name Data type Size Property short name Value flag UUI order
Name VARCHAR 80 NAME R 1
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
For further information . . . VARCHAR 80 RESPNSBL O
URL to access data VARCHAR 254 URL O
Timestamp source definition last changed CHAR 26 SRCDATCF O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Elements

Represents MDIS element objects that do not map directly to the Columns or fields object type.

The tag language for defining this object type is in the file FLGNYELE.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.ELEMENT. For more information on table names, see MDIS mappings.

Table 84 provides information about the properties of the Elements object type.

Table 84. Properties of the Elements object type
The MDIS name for this object type is Element.
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
For further information... VARCHAR 80 RESPNSBL O
Element last refreshed CHAR 26 FRESHDAT O
Database host server name VARCHAR 80 SERVER R 1
Database or subsystem name VARCHAR 80 DBNAME R 2
Element owner VARCHAR 80 OWNER R 3
Dimension or record name VARCHAR 80 DIMRECNM R 4
Element name VARCHAR 80 ELEMNAME R 5
URL to access data VARCHAR 254 URL O
Data type of element CHAR 30 DATATYPE O
Length of element CHAR 20 LENGTH O
Scale of element CHAR 5 SCALE O
Precision of element CHAR 5 PRECDIG O
Can element be null CHAR 1 NULLS O
Position of element within primary key CHAR 5 KEYPOSNO O
Element position CHAR 5 POSNO O
Element ordinality CHAR 5 ORDINAL O
Timestamp source definition created CHAR 26 CRTTIME O
Timestamp source definition last changed CHAR 26 SRCDATCF O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Files

Represents a file within a file system.

The tag language for defining this object type is in the file FLGNYFIL.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.FILE. For more information on table names, see MDIS mappings.

Table 85 provides information about the properties of the Files object type.

Table 85. Properties of the Files object type
The MDIS name for this object type is Record.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
RecordLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short Description VARCHAR 250 SHRTDESC O
BriefDescription
Long Description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
File owner VARCHAR 80 OWNER R 3 OwnerName
File path or directory VARCHAR 254 FILEPATH R 4 ApplicationData
File filename VARCHAR 254 FILENAME R 5 RecordName
File data last refreshed CHAR 26 FRESHDAT O
RecordLastRefreshDate
Transformation program last run CHAR 26 LASTRUN O
ApplicationData
Transformation program run frequency VARCHAR 80 RUNFREQ O
RecordUpdateFrequency
Transformation program type VARCHAR 32 SOURCE O
ApplicationData
Partial or full file copy/update CHAR 1 COPYCOMP O
ApplicationData
Copied/updated data is in a consistent state CHAR 1 CONSIST O
ApplicationData
Transformation program last changed CHAR 26 PGMGEND O
ApplicationData
Transformation program last compiled CHAR 26 PGMCOMP O
ApplicationData
File class or type VARCHAR 80 TYPE O
RecordType
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

IMS database definitions (DBD)

Represents IMS database definitions.

The tag language for defining this object type is in the file FLGNYDBD.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.IMSDBD. For more information on table names, see MDIS mappings.

Table 86 provides information about the properties of the IMD database definitions (DBD) object type.

Table 86. Properties of the IMS database definitions (DBD) object type
The MDIS name for this object type is Database.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
DatabaseLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
Database last refreshed CHAR 26 FRESHDAT O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database owner VARCHAR 80 OWNER O
OwnerName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database server type VARCHAR 80 SRVRTYPE O
ServerType
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Database type VARCHAR 80 DBTYPE R 3 DatabaseType
Database extended type VARCHAR 40 DBETYPE O
ApplicationData
Database status VARCHAR 80 DBSTAT O
DatabaseStatus
IMS access method VARCHAR 80 IMSACC O
ApplicationData
Operating system access method VARCHAR 80 OSACC O
ApplicationData
Shared index names VARCHAR 320 SHRINDEX O
ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

IMS program control blocks (PCB)

Represents IMS program control blocks.

The tag language for defining this object type is in the file FLGNYPCB.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.IMSPCB. For more information on table names, see MDIS mappings.

Table 87 provides information about the properties of the IMS program control blocks (PCB) object type.

Table 87. Properties of the IMS program control blocks (PCB) object type
The MDIS name for this object type is Subschema.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
SubschemaLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
PCB name VARCHAR 80 PCBNAME R 3 SubschemaName
PCB owner VARCHAR 80 OWNER O
OwnerName
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

IMS program specification blocks (PSB)

Represents IMS program specification blocks.

The tag language for defining this object type is in the file FLGNYPSB.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.PSB. For more information on table names, see MDIS mappings.

Table 87 provides information about the properties of the IMS program specification blocks (PSB) object type.

Table 88. Properties of the IMS program specification blocks (PSB) object type
The MDIS name for this object type is Subschema.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
DatabaseLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database server type VARCHAR 80 SRVRTYPE O
ServerType
Database type VARCHAR 80 DBTYPE R 3 DatabaseType
Database extended type VARCHAR 40 DBETYPE O
ApplicationData
Database status VARCHAR 80 DBSTAT O
DatabaseStatus
PSB name VARCHAR 80 PSBNAME R 2 DatabaseName
PSB owner VARCHAR 80 OWNER O
OwnerName
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

IMS segments

Represents IMS segments.

The tag language for defining this object type is in the file FLGNYSEG.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.IMSSEG. For more information on table names, see MDIS mappings.

Table 89 provides information about the properties of the IMS segments object type.

Table 89. Properties of the IMS segments object type
The MDIS name for this object type is Record.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
RecordLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short Description VARCHAR 250 SHRTDESC O
BriefDescription
Long Description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
Segment last refreshed CHAR 26 FRESHDAT O
RecordLastRefreshDate
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER O
ServerName
Database or subsystem name VARCHAR 80 DBNAME R 1 DatabaseName
Segment name VARCHAR 80 SEGNAME R 2 RecordName
Segment owner VARCHAR 80 OWNER O
OwnerName
Segment type VARCHAR 80 TYPE O
RecordType
Segment maximum length CHAR 5 MAXLEN O
ApplicationData
Segment minimum length CHAR 5 MINLEN O
ApplicationData
Real logical child segment source CHAR 20 PSEGSRC O
ApplicationData
Logical parent concatenated key source CHAR 20 LPCKSRC O
ApplicationData
Transformation program last run CHAR 26 LASTRUN O
ApplicationData
Transformation program run frequency VARCHAR 80 RUNFREQ O
RecordUpdateFrequency
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Members within a multidimensional database

Represents a member within a multidimensional database. A member is part of a dimension, and a dimension is part of a multidimensional database.

The tag language for defining this object type is in the file FLGNYMEM.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.MEMBER. For more information on table names, see MDIS mappings.

Table 90 provides information about the properties of the Members within a multidimensional database object type.

Table 90. Properties of the Members within a multidimensional database object type
The MDIS name for this object type is Element.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name CHAR 80 NAME R
ElementLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information VARCHAR 80 RESPNSBL O
ContactName
Member last refreshed CHAR 26 FRESHDAT O
ElementLastRefreshDate
Member owner VARCHAR 80 OWNER O
OwnerName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Using application name VARCHAR 80 APPLNAME R 3 ApplicationData
Dimension name VARCHAR 80 DIMENSON R 4 DimensionName
Member name VARCHAR 80 MEMBER R 5 ElementName
Data type of member CHAR 30 DATATYPE O
ElementDataType
Length of member CHAR 20 LENGTH O
ElementLength
Scale of member CHAR 5 SCALE O
ApplicationData
Precision of member CHAR 5 PRECDIG O
ElementPrecision
Can member be null CHAR 1 NULLS O
ElementNulls
Position of member within primary key CHAR 5 KEYPOSNO O
ElementKeyPosition
Member position CHAR 5 POSNO O
ElementPosition
Member ordinality CHAR 5 ORDINAL O
ElementOrdinality
Derived from... VARCHAR 512 DERIVED O
ApplicationData
Application-specific information VARCHAR 512 APPLDATA O
ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Multidimensional databases

Represents multidimensional databases.

The tag language for defining this object type is in the file FLGNYOLA.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.OLAPMODL. For more information on table names, see MDIS mappings.

Table 91 provides information about the properties of the Multidimensional databases object type.

Table 91. Properties of the Multidimensional databases object type
The MDIS name for this object type is Database.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
DatabaseLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database last refreshed CHAR 26 FRESHDAT O
ApplicationData
Database owner VARCHAR 80 OWNER O
OwnerName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database server type VARCHAR 80 SRVRTYPE O
ServerType
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Database type VARCHAR 80 DBTYPE O
DatabaseType
Database extended type VARCHAR 20 DBETYPE O
ApplicationData
Database status VARCHAR 80 DBSTAT O
DatabaseStatus
Using application name VARCHAR 80 APPLNAME R 3 ApplicationData
Application-specific information VARCHAR 512 APPLDATA O
ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Records

Represents MDIS Record objects that do not map directly to the "Files" or "Relational tables or views" object types. Records are comprised of elements.

The tag language for defining this object type is in the file FLGNYREC.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.RECORD. For more information on table names, see MDIS mappings.

Table 92 provides information about the properties of the Records object type.

Table 92. Properties of the Records object type
The MDIS name for this object type is Record.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
RecordLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Record owner VARCHAR 80 OWNER R 3 OwnerName
Record name VARCHAR 80 RECNAME R 4 RecordName
Record data last refreshed CHAR 26 FRESHDAT O
RecordLastRefreshDate
Transformation program last run CHAR 26 LASTRUN O
ApplicationData
Transformation program run frequency VARCHAR 80 RUNFREQ O
RecordUpdateFrequency
Record type VARCHAR 80 TYPE O
RecordType
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Relational tables and views

Represents tables or views of relational databases.

The tag language for defining this object type is in the file FLGNYTAB.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.TABLES. For more information on table names, see MDIS mappings.

Table 93 provides information about the properties of the Relational tables and views object type.

Table 93. Properties of the Relational tables and views object type
The MDIS name for this object type is Record.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
RecordLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short Description VARCHAR 250 SHRTDESC O
BriefDescription
Long Description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
Catalog remarks VARCHAR 254 REMARKS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER O
ServerName
Local database alias CHAR 8 DBALIAS O
ApplicationData
Database or subsystem name VARCHAR 80 DBNAME R 1 DatabaseName
Table owner VARCHAR 80 OWNER R 2 OwnerName
Table name VARCHAR 80 TABLES R 3 RecordName
Base table owner name CHAR 30 SRCOWNER O
ApplicationData
Base table name CHAR 128 SRCTBNAM O
ApplicationData
Table data last refreshed CHAR 26 FRESHDAT O
RecordLastRefreshDate
Transformation program run mode CHAR 30 RUNMODE O
ApplicationData
Transformation program last run CHAR 26 LASTRUN O
ApplicationData
Transformation program run frequency VARCHAR 80 RUNFREQ O
RecordUpdateFrequency
Transformation program type VARCHAR 32 SOURCE O
ApplicationData
Partial or full table copy/update CHAR 1 COPYCOMP O
ApplicationData
Copied/updated data is in a consistent state CHAR 1 CONSIST O
ApplicationData
Catalog refresh/update frequency VARCHAR 80 REFRESH O
ApplicationData
Transformation program last changed CHAR 26 PGMGEND O
ApplicationData
Transformation program last compiled CHAR 26 PGMCOMP O
ApplicationData
Table type VARCHAR 80 TYPE O
RecordType
Definition represents a view CHAR 1 TABLVIEW O
ApplicationData
Internal name of table CHAR 18 IDSINAME O
ApplicationData
Table is used as a dimension table CHAR 1 IDSDIM O
ApplicationData
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Star Schemas

Represents relational data.

The tag language for defining this object type is in the file FLGNYSUB.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.STARSCHM. For more information on table names, see MDIS mappings.

Table 94 provides information about the properties of the Business subject areas object type.

Table 94. Properties of the Star Schemas object type
Property name Data type Size Property short name Value flag UUI order
Name VARCHAR 80 NAME R 1
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
For further information . . . VARCHAR 80 RESPNSBL O
URL to access data VARCHAR 254 URL O
Timestamp source definition last changed CHAR 26 SRCDATCF O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Subschemas

Represents logical groupings of records within a database.

The tag language for defining this object type is in the file FLGNYSUB.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.SUBSCHEM. For more information on table names, see MDIS mappings.

Table 95 provides information about the properties of the Subschemas object type.

Table 95. Properties of the Subschemas object type
The MDIS name for this object type is Subschema.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
SubschemaLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
For further information... VARCHAR 80 RESPNSBL O
ContactName
Database host server name VARCHAR 80 SERVER R 1 ServerName
Database or subsystem name VARCHAR 80 DBNAME R 2 DatabaseName
Subschema owner VARCHAR 80 OWNER O
OwnerName
Subschema name VARCHAR 80 SSNAME R 3 SubschemaName
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Transformations

Represents expressions or logic used to populate columns of data within the target relational database. Transformations objects indicate either the expression used to convert source operational data to target columns or the one-to-one mapping of source fields to target columns.

The tag language for defining this object type is in the file FLGNYFLT.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.FILTER. For more information on table names, see MDIS mappings.

Table 96 provides information about the properties of the Transformations object type.

Table 96. Properties of the Transformations object type
The MDIS name for this object type is Relationship.
Property name Data type Size Property short name Value flag UUI order Maps to MDIS name:
Object type identifier CHAR 6 OBJTYPID S

Instance identifier CHAR 10 INSTIDNT S

Name VARCHAR 80 NAME R
RelationshipLongName
Last Changed Date and Time TIMESTAMP 26 UPDATIME S

Last Changed By CHAR 8 UPDATEBY S

Short description VARCHAR 250 SHRTDESC O
BriefDescription
Long description LONG VARCHAR 32700 LONGDESC O
LongDescription
Actions VARCHAR 254 ACTIONS O
ApplicationData
Transformation program name VARCHAR 80 FPNAME R 1 ApplicationData
Transformation identifier VARCHAR 254 FIDENT R 2 RelationshipName
Transformation class or type VARCHAR 80 TYPE R 3 RelationshipType
Source column/field name, expression or parameters LONG VARCHAR 32700 FEXPRESS O
RelationshipExpression
Database host server name VARCHAR 80 SERVER O
ServerName
Transformation owner VARCHAR 80 OWNER O
OwnerName
Source sequence CHAR 5 SRCSEQ O
SourceSequenceOrder
Transformation ordinality CHAR 5 ORDINAL O
RelationshipOrdinality
Transformation bi-directionality CHAR 1 DIRECT O
RelationshipBidirectional
URL to access data VARCHAR 254 URL O
ApplicationData
Timestamp source definition created CHAR 26 CRTTIME O
DateCreated, TimeCreated
Timestamp source definition last changed CHAR 26 SRCDATCF O
DateUpdated, TimeUpdated
For further information... VARCHAR 80 RESPNSBL

ContactName
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Elemental category

The Elemental category contains the following object types:

Audio clips

Represents files that contain audio information. These objects might represent electronic (AUD files) or printed (for example, CDs, tapes) audio information.

The tag language for defining this object type is in the file FLGNYAUD.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.AUDIO. For more information on table names, see MDIS mappings.

Table 97 provides information about the properties of the Audio clips object type.

Table 97. Properties of the Audio clips object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Audio clip filename VARCHAR 254 FILENAME R 1
Audio clip class or type VARCHAR 80 TYPE R 2
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Charts

Represents either printed or electronic charts.

The tag language for defining this object type is in the file FLGNYCHA.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.CHARTS. For more information on table names, see MDIS mappings.

Table 98 provides information about the properties of the Charts object type.

Table 98. Properties of the Charts object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Chart title VARCHAR 254 TITLE O
Chart publication date CHAR 26 RPRTDATE O
Chart presentation format VARCHAR 80 RPRTFRMT O
Chart presentation requirements VARCHAR 254 DPPRESNT O
Chart owner VARCHAR 80 OWNER O
Chart filename VARCHAR 254 FILENAME R 1
Chart class or type VARCHAR 80 TYPE R 2
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Documents

Represents books and technical papers. These publications might be printed or electronic, found locally or within a library.

The tag language for defining this object type is in the file FLGNYDOC.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.DOCS. For more information on table names, see MDIS mappings.

Table 99 provides information about the properties of the Documents object type.

Table 99. Properties of the Documents object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Document author VARCHAR 80 AUTHOR R 1
Document location VARCHAR 254 LOCATION R 2
Document filename VARCHAR 254 FILENAME R 3
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Images or graphics

Represents graphic images, such as bitmaps.

The tag language for defining this or graphics object type is in the file FLGNYIMA.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.IMAGES. For more information on table names, see MDIS mappings.

Table 100 provides information about the properties of the Images or graphics object type.

Table 100. Properties of the Images or graphics object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Image filename VARCHAR 254 FILENAME R 1
Image class or type VARCHAR 80 TYPE R 2
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Internet documents

Represents Web sites and other documents on the Internet that might be of interest.

The tag language for defining this object type is in the file FLGNYINT.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.INTERNET. For more information on table names, see MDIS mappings.

Table 101 provides information about the properties of the Internet documents object type.

Table 101. Properties of the Internet documents object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
URL to access data VARCHAR 254 URL R 1
Local filename VARCHAR 254 FILENAME R 2
Internet document class or type VARCHAR 80 TYPE O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Lotus Approach queries

Represents Lotus Approach queries for available use with your organization's data.

The tag language for defining this object type is in the file FLGNYAPR.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.APPROACH. For more information on table names, see MDIS mappings.

Table 102 provides information about the properties of the Lotus Approach queries object type.

Table 102. Properties of the Lotus Approach queries object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Approach object filename VARCHAR 254 FILENAME R 1
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Presentations

Represents printed or electronic presentations. These presentations might include product, customer, quality, and status presentations.

The tag language for defining this object type is in the file FLGNYPRE.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.PRESENT. For more information on table names, see MDIS mappings.

Table 103 provides information about the properties of the Presentations object type.

Table 103. Properties of the Presentations object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Presentation filename VARCHAR 254 FILENAME R 1
Presentation class or type VARCHAR 80 TYPE O
Presentation script VARCHAR 254 SCRIPTFN O
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Spreadsheets

Represents desktop spreadsheets (for example, Lotus 1-2-3 or Microsoft Excel spreadsheets).

The tag language for defining this object type is in the file FLGNYSSH.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.SSHEETS. For more information on table names, see MDIS mappings.

Table 104 provides information about the properties of the Spreadsheets object type.

Table 104. Properties of the Spreadsheets object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Spreadsheet class or type VARCHAR 80 TYPE O
Spreadsheet filename VARCHAR 254 FILENAME R 1
Spreadsheet bitmap <captured> filename VARCHAR 254 BITMAP O
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Text-based reports

Represents either printed or electronic reports.

The tag language for defining this object type is in the file FLGNYREP.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.REPORTS. For more information on table names, see MDIS mappings.

Table 105 provides information about the properties of the Text-based reports object type.

Table 105. Properties of the Text-based reports object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Report title VARCHAR 254 TITLE R
Report publication date CHAR 26 RPRTDATE O
Report presentation format VARCHAR 80 RPRTFRMT O
Report presentation requirements VARCHAR 254 DPPRESNT O
Report owner VARCHAR 80 OWNER O
Report filename VARCHAR 254 FILENAME R 1
Report class or type VARCHAR 80 TYPE R 2
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Video clips

Represents files that contain video information. These objects might represent electronic (AVI files) or printed (for example, video tapes or laser disks) video information.

The tag language for defining this object type is in the file FLGNYVID.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.VIDEO. For more information on table names, see MDIS mappings.

Table 106 provides information about the properties of the Video clips object type.

Table 106. Properties of the Video clips object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Video clip filename VARCHAR 254 FILENAME R 1
Video clip class or type VARCHAR 80 TYPE R 2
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Contact category

The Contact category contains the People to contact object type.

People to contact

The People to contact object type identifies a person or group that is responsible for objects within the information catalog.

The tag language for defining the People to contact object type is in the file FLGNYCON.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.CONTACT. For more information on table names, see MDIS mappings.

Table 107 provides information about the properties of the People to contact object type.

Table 107. Properties of the People to contact object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Contact's responsibility VARCHAR 254 RESPONSE R 2
Contact's phone number CHAR 15 PHONE R
Contact's e-mail address VARCHAR 254 EMAIL R
Contact's picture filename VARCHAR 254 FILENAME O
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Dictionary category

The Dictionary category contains the Glossary entries object type.

Glossary entries

The Glossary entries object type represents definitions for terms used in the information catalog. Its properties are shown in Table 108.

The tag language for defining the Glossary entries object type is in the file FLGNYGLO.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.GLOSSARY. For more information on table names, see MDIS mappings.

Table 108 provides information about the properties of the Glossary entries object type.

Table 108. Properties of the Glossary entries object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Keywords VARCHAR 254 KEYWORD O
Context of glossary definition CHAR 32 CONTEXT O
Filename containing glossary definition VARCHAR 254 FILENAME O
Glossary class or type VARCHAR 80 TYPE O
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Support category

The Support category contains the following object types:

Information Catalog Manager news

The Information Catalog Manager news object type contains information about changes to the information catalog.

The tag language for defining the Information Catalog Manager news object type is in the file FLGNYDGN.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.DGNEWS. For more information on table names, see MDIS mappings.

Table 109 provides information about the properties of the Information Catalog Manager news object type.

Table 109. Properties of the Information Catalog Manager news object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
News item date CHAR 26 NEWSDATE R
News clip VARCHAR 254 ABSTRACT R
Full news item LONG VARCHAR 32700 NEWSITEM O
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Online news services

The Online news services object type represents news and information services that can be accessed online.

The tag language for defining the Online news services object type is in the file FLGNYOLN.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.OLNEWS. For more information on table names, see MDIS mappings.

Table 110 provides information about the properties of the Online news services object type.

Table 110. Properties of the Online news services object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Service name VARCHAR 254 SERVNAME R
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Online publications

The Online publications object type represents publications and other documents that can be accessed with online services.

The tag language for defining the Online publications object type is in the file FLGNYOLP.TYP in the \VWSWIN\DGWIN\TYPES directory.

The Information Catalog Manager DB2 storage table name for this object type is XXX.OLPUBS. For more information on table names, see MDIS mappings.

Table 111 provides information about the properties of the Online publications object type.

Table 111. Properties of the Online publications object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Short description VARCHAR 250 SHRTDESC O
Long description LONG VARCHAR 32700 LONGDESC O
Actions VARCHAR 254 ACTIONS O
Service name VARCHAR 254 SERVNAME R
URL to access data VARCHAR 254 URL O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Program category

The Program category can only contain the Programs object type.

The Programs object type is created when an information catalog is created. In the sample information catalog, DGV5SAMP, the Programs object type is named Programs that can be invoked from Information Catalog Manager objects.

Programs that can be invoked from Information Catalog Manager objects

Used to define an application that is capable of processing a particular object type.

The Information Catalog Manager DB2 storage table name for this object type is XXX.GLOSSARY. For more information on table names, see MDIS mappings.

Table 112 provides information about the properties of the Programs that can be invoked from Information Catalog Manager objects object type.

Table 112. Properties of the "Programs that can be invoked from Information Catalog Manager objects" object type
Property name 1 Data type Size Property short name Value flag 2 UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Class CHAR 25 UUICLASS R 1
Qualifier 1 VARCHAR 48 UUIQUAL1 R 2
Qualifier 2 VARCHAR 48 UUIQUAL2 R 3
Qualifier 3 VARCHAR 48 UUIQUAL3 R 4
Identifier VARCHAR 70 UUIDENT R 5
Object type this program handles CHAR 8 HANDLES O
Start by invoking VARCHAR 250 STARTCMD R
Parameter list is VARCHAR 1800 PARMLIST O
Short description VARCHAR 250 SHRTDESC O
Note:
  1. Descriptions and examples of the required properties are in Information Catalog Manager Administration Guide.
  2. S = generated by the Information Catalog Manager, R = required, O = optional

Attachment category

The Attachment category can contain only the Comments object type.

The Comments object type is created when an information catalog is created.

Comments

Used to comment on other objects in the information catalog.

Table 113 provides information about the properties of the Comments object type.

Table 113. Properties of the Comments object type
Property name Data type Size Property short name Value flag UUI order
Object type identifier CHAR 6 OBJTYPID S
Instance identifier CHAR 10 INSTIDNT S
Name VARCHAR 80 NAME R 1
Last Changed Date and Time TIMESTAMP 26 UPDATIME S
Last Changed By CHAR 8 UPDATEBY S
Creator CHAR 8 CREATOR R 2
Creation time stamp TIMESTAMP 26 CREATSTP R 3
Status CHAR 80 STATUS O
Actions VARCHAR 250 ACTIONS O
Extra Information VARCHAR 80 EXTRA O
Long Description LONG VARCHAR 32700 LONGDESC O
Note:S = generated by the Information Catalog Manager, R = required, O = optional

Predefined program objects

Program object types shown in Table 114 are provided in the sample information catalog. The table also shows the property name that you use to associate with the Information Catalog Manager program object when launching a program.

Table 114. Generic predefined program objects in the sample information catalog
Type of information Program name Object type Property name
Multimedia files Microsoft Media Player Audio clips Audio clip filename

Microsoft Media Player Business subject areas Filename

Microsoft Media Player Presentations Presentation filename

Microsoft Media Player Video clips Video clip filename
Bitmap files Microsoft Paint Images or graphics Graphic filename

Microsoft Paint People to contact Contact's picture filename
Spreadsheet files Microsoft Excel Spreadsheets Spreadsheet filename

Microsoft Paint Spreadsheets Spreadsheet filename

Lotus 1-2-3 Spreadsheets Spreadsheet filename
Web pages Netscape Navigator Online news URL to access data

Netscape Navigator Online publications URL to access data

Microsoft Internet Explorer Internet documents URL to access data

Microsoft Internet Explorer Online news URL to access data

Microsoft Internet Explorer Online publications URL to access data

Table 115 lists specific IBM Business Partners who have applications that are integrated with the Information Catalog Manager. The information in this table similar to that in Table 114.

Table 115. Predefined program objects in sample information catalog -- IBM Business Partners
Type of information Program name Object type Property name
Lotus Approach Lotus Approach Approach object filename

Freelance Graphics Presentations Presentation object filename
Hyperion Lotus 1-2-3 with Essbase Spreadsheet add-in Spreadsheets Spreadsheet filename

Microsoft Excel with Essbase Spreadsheet add-in Spreadsheets Spreadsheet filename
Brio Brio Query Text based reports Report filename

Netscape Navigator (use with Brio.Insights plug-in) Text based reports URL to access data

Microsoft Internet Explorer (use with Brio.Insights plug-in) Text based reports URL to access data
BusinessObjects BusinessObjects Databases None

BusinessObjects Text based reports Report filename

Microsoft Excel (used with BusinessQuery add-in) Spreadsheets Spreadsheet filename

Microsoft Internet Explorer (used to access WebIntelligence Java applet) Internet documents URL to access data

Netscape Navigator (used to access WebIntelligence Java applet) Internet documents URL to access data
Cognos PowerPlay Text-based reports Report filename

Impromptu Text-based reports Report filename

Microsoft Internet Explorer (used with Impromtu Web Query) Internet documents URL to access data

Netscape Navigator (used with Impromptu Web Query) Internet documents URL to access data

Netscape Navigator (used to access PowerPlay Web edition HTML pages) Internet documents URL to access data
Wired for OLAP Wired for OLAP View Text-based reports configure Default user login, and Startup options

Wired for OLAP Home Page within Netscape Text-based reports configure Default user login, and Startup options

Wired for OLAP Home Page within Microsoft Internet Explorer Text-based reports configure Default user login, and Startup options
Seagate Crystal Reports Text-based reports Report filename
Microsoft Access Microsoft Access Database
Microsoft PowerPoint Microsoft PowerPoint Viewer Text-based reports Report filename

Microsoft PowerPoint Viewer within Netscape Text-based reports URL to access data

Microsoft PowerPoint Viewer within Microsoft Internet Explorer Text-based reports URL to access data

[ Top of Page | Previous Page | Next Page ]