The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
with Tags:
tips
X
X
Troubleshooting Tips: ODBC Common connector for DB2 on AS400/system i - Columns with VARCHAR ( >254) seen as LOBs
Using ODBC CC to access DB2 ISeries
(AS400) tables, job reports LOB error when no LOB data types are defined
on the table and fails with the following message. ODBC_Connector_0,0: The array size must be set to 1 when reading LOBs
(CC_OdbcDBRecordDataSetProducer::dbsAllocateBindBuffers, file
CC_OdbcDBRecordDataSetProducer.cpp, line 571) This
is typical due to how AS400 treats this type of columns. VARCHAR (>254)
will be seen as LongVarChar (LOB) in ODBC CC. The following table is the data type mapping for DB2 for i Resolution... [More]
Tags: troubleshooting tips |
Troubleshooting Tips: DataStage job migration from previous version to latest version 9.1
If you are working on the InfoSphere DataStage migration project and migrating to the latest version 9.1 on the Windows operating system, please aware of the following requirement. You must
recompile jobs that contain the following operators Transform Buildop Conditional lookups Range lookup Slowly changing dimensions The root cause of the issue is that all the above operators on Windows in Version 9.1 include updates for memory
allocation for use with the Visual Studio 2010 Compiler Version.
Hope this help!! Happy Reading!! ... [More]
Tags: tips migration troubleshooting datastage |
