Support for LOB Datatypes in DB2 for z/OS Data Maps
Support for LOB Datatypes in DB2 for z/OS Data Maps
PowerExchange introduces support for LOB datatypes in DB2 for z/OS data maps. LOB datatypes include BLOB, CLOB, and DBCLOB.
In the PowerExchange Navigator, you can define a data map for a DB2 for z/OS data source that includes LOB columns. After you define the data map, you can perform a database row test on the table, and you can include the table as a source in a PowerCenter bulk data movement session.
Because DB2 is a relational database, a DB2 data map is not required for PowerExchange to access DB2 tables. However, in certain cases, defining a data map allows you to process the data in a way that is not otherwise possible. For example, if a CHAR column contains multiple packed decimal fields, you can define a DB2 data map to split data in the CHAR column into separate columns with the correct datatype for the content.
The maximum length of a DB2 row with LOB columns that you can define in a data map or include in a PowerExchange bulk data movement operation is 8 MB.
In a bulk data movement session, PowerExchange already provides support for LOB columns in DB2 data sources for which a data map is not defined.
For more information, see the "Data Maps for Specific Data Sources" chapter in the