Search found 3 matches
- Tue Oct 12, 2010 5:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: using odbc connector, find data string , right truncation
- Replies: 3
- Views: 1618
I have replace ODBC CONNECTOR with PEEK stage,and there's no error as before(actually It's not a fatal or warning).I've check that max length of the records is 302839,so I couldn't use varchar. It's strange that extracting only one record is right,but extracting all records will lead before 'error'....
- Tue Oct 12, 2010 3:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: using odbc connector, find data string , right truncation
- Replies: 3
- Views: 1618
using odbc connector, find data string , right truncation
Hello, I extract ntext field of Sql Server to nclob of Oracle.Job like bellow. odbc connector ------> transformer ------>odbc connector Transformer stage use longnvarchar,length unset.Data counts is about 60000.When extract all datas I get the information(not warning or fatal) from destination stage...
- Tue Oct 12, 2010 3:05 am
- Forum: General
- Topic: using odbc connector, find data string , right truncation
- Replies: 0
- Views: 672
using odbc connector, find data string , right truncation
Hello, I extract ntext field of Sql Server to nclob of Oracle.Job like bellow. odbc connector ------> transformer ------>odbc connector Transformer stage use longnvarchar,length unset.Data counts is about 60000.When extract all datas I get the information(not warning or fatal) from destination stage...