[DataStage][SQL Client]Data has been truncated

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dhar.bn
Participant
Posts: 4
Joined: Mon Apr 06, 2009 1:54 am
Location: bangalore

[DataStage][SQL Client]Data has been truncated

Post by dhar.bn »

Hi,
Can anyone suggest me how to resolve this issue

SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=22001, DBMS.CODE=-302
[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small.
shashidhar BN
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

"Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small."

First suggestion would be to look for this situation, find out where you are trying to put more information into a field than will fit.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply