I'm having problems with sql3119w error when I try to load a table. I cannot understand but the table has a field (integer type) in which I'll try to load a decimal (9,0) type data. The system said: "The field value in row "F1-1" and column "3" cannot be converted to an INTEGER value. A null was loaded."
I'm trying with sentence:
CALL sysproc.admin_cmd ('
load from "/database/xxx" of ASC
MODIFIED BY NOHEADER CODEPAGE=284 DATEFORMAT="YYYY-MM-DD" PACKEDDECIMAL BINARYNUMERICS RECLEN=219
Warningcount 10 MESSAGES ON SERVER TEMPFILES PATH "/database/reject/"
REPLACE INTO "eeeeeeeee"."table_name_for_me"
camp1, camp2, camp3
NONRECOVERABLE DATA BUFFER 200000 CPU_PARALLELISM 24 DISK_PARALLELISM 50 ' );
Please, somebody can help me?