Unanswered: '|' symbol in a column rejected while loading
In the process of migrating the data from sybase to IBM DB2. The following error has been encountered while loading the table in DB2. The table is having the symbol - '|' in a column in few rows. And those particular rows are being rejected.
Any clue for this error.
SQL3116W The field value in row "95257" and column "4" is missing, but the target column is not nullable.
SQL3185W The previous error occurred while processing data from row "95988" of the input file.
SQL3116W The field value in row "96054" and column "4" is missing, but the target column is not nullable.
Hi Julian and Bala,
Initially I gave this load utility command:
LOAD FROM 'D:\Table1.prod' OF DEL MODIFIED BY CHARDEL| COLDEL~ KEEPBLANKS TIMESTAMPFORMAT="MMM DD YYYY HH:MMS:UUUTT" MESSAGES "C:\DBLog1.log" REPLACE INTO SCHEMA.Table1;
Now, I tried with this by mentioning CHARDEL<
LOAD FROM 'D:\Table1.prod' OF DEL MODIFIED BY CHARDEL< COLDEL~ KEEPBLANKS TIMESTAMPFORMAT="MMM DD YYYY HH:MMS:UUUTT" MESSAGES "C:\DBLog1.log" REPLACE INTO SCHEMA.Table1;
But, again the rows were not read.It has thrown this error SQL3115W The field value beginning "<....." is longer than the longest allowable table column. The value was truncated.
Sample row of input is:
^9999~Aug 15 1947 12:00:00:000AM~2~A~FIRST SECOND ~1~1~1~11~YYY001~May 11 1857 1:37:09:220AM^9999~...second row continued...
Thanks for the reply.
What is the function of chardel in the Load Utility command?
Since in my data I am not having '|' in any of the rows and moreover in the data originally I have '~' or '^' as delimiters.
What if I skip mentioning chardel in Load Utility command?