datatype error which colum is it ?
Posted on 2005-05-09
i am running this insert statement if i insert first 100 or 500 rows its k, but if i do full load the error occur can u plz advice which column datatype should i increase as i know its datatype lenght problem but which column how can i know that ??
INSERT INTO db2admin.STG_Cust1 ( SELECT
RRR_CUST1.CUSTNO, RRR_CUST1.RECCD, RRR_CUST1.CNAME,
RRR_CUST1.CADD1, RRR_CUST1.CADD2, RRR_CUST1.CTYPRV,
RRR_CUST1.CPOSTL, RRR_CUST1.CUSER1, RRR_CUST1.CUSER2,
RRR_CUST1.CCRDT3, RRR_CUST1.CRVDT3, RRR_CUST1.CSPCON,
RRR_CUST1.FILL01, RRR_CUST1.CCTCTY, RRR_CUST1.C1STAT
DB21034E The command was processed as an SQL
statement because it was not a
valid Command Line Processor command. During SQL
processing it returned:
SQL0433N Value "US" is too long. SQLSTATE=22001
SQL0433N Value "US
" is too long.
The value "<value>" required truncation by a system
cast or adjustment function, which was called to
value in some way. The truncation is not allowed
value is used.
The value being transformed is one of the following:
o an argument to a user defined function (UDF)
o an input to the SET clause of an UPDATE statement
o a value being INSERTed into a table
o an input to a cast or adjustment function in some
o a recursively referenced column whose data type
and length is
determined by the initialization part of recursion
grow in the iterative part of the recursion.
The statement has failed.
If "<value>" is a literal string in the SQL statement,
it is too
long for its intended use.
If "<value>" is not a literal string, examine the SQL
to determine where the transformation is taking place.
input to the transformation is too long, or the target
Correct the problem and rerun the statement.
sqlcode : -433
sqlstate : 22001