Search found 4 matches
- Thu Feb 18, 2016 2:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch XML CLOB data through Oracle Connector faster
- Replies: 9
- Views: 6121
- Thu Feb 18, 2016 12:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch XML CLOB data through Oracle Connector faster
- Replies: 9
- Views: 6121
- Wed Feb 17, 2016 12:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch XML CLOB data through Oracle Connector faster
- Replies: 9
- Views: 6121
Thanks for your reply. But my select query already had this CLOB column in last position. And I have kept the datatype as LongVarChar. Do you have any other suggestions as to what values to set for array size, record count, buffer size etc? Or please let me know if I could use some other stage to pe...
- Tue Feb 16, 2016 5:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch XML CLOB data through Oracle Connector faster
- Replies: 9
- Views: 6121
Fetch XML CLOB data through Oracle Connector faster
Hi , I am trying to read 4 columns from Oracle database using a SELECT query in Oracle connector. One of the columns has CLOB data type in the Oracle database. The query has a WHERE clause to fetch data for a single day. If I run the query in SQL Developer it finishes in 90 sec for 70,000 records. W...