using odbc connector, find data string , right truncation

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
ryy2222
Participant
Posts: 2
Joined: Tue Oct 12, 2010 2:33 am

using odbc connector, find data string , right truncation

Post by ryy2222 »

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:
ODBC_Connector_27,0: [IIS-CONN-ODBC-000013] ODBC Info: SQLSTATE = 01004: Native Error Code = 0: Msg = [Microsoft][ODBC SQL Server Driver]data string , right truncation
But when I extract only one and the largest length data,no that information.Can anyone help me?

best wishes
Top
Post Reply

Return to “General”