Search found 3 matches

by kevinz
Wed Jul 08, 2015 5:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading LOBs with RCP
Replies: 7
Views: 9192

Yes indeed, we can still keep RCP on, but instead of having nothing to do for the column definition (just select *) we now have to do some extra work and lose a bit of the simplicity in the process (I am also lazy :oops:) . Shane, I understand your suggestion of generating the Select statement based...
by kevinz
Tue Jul 07, 2015 8:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading LOBs with RCP
Replies: 7
Views: 9192

Shane, this is the error message: "GenTargetTable,1: The array size must be set to 1 when reading LOBs (CC_OdbcDBRecordDataSetConsumer::dbsAllocateBindBuffers, file CC_OdbcDBRecordDataSetConsumer.cpp, line 785)" So we added Array Size = 1 to: 1) the target: ODBC Connector Stage for Sybase ...
by kevinz
Mon Jul 06, 2015 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading LOBs with RCP
Replies: 7
Views: 9192

Reading LOBs with RCP

Hello, I am using the DB2 Connector Stage as a source with RCP on, in order to avoid having to define the columns definition (select * from my_table). The goal is to load 300+ tables with a generic job, so RCP comes in handy. However, the issue is when the table has LOBs columns... This is from IBM:...