Problem with LOAD TABLE

48 Views

I'm loading a table and is giving error.

FILE:

4762613000|00131002|5600| |01/01/1970|10/03/201409:40:57.000000|10/03/2014 10:14:24.000000|0|

4762613001|00131002|5601| |01/01/1970|10/03/201409:43:46.000000|10/03/2014 10:14:24.000000|0|

4762613002|00131002|5605| |01/01/1970|10/03/201409:47:25.000000|10/03/2014 10:14:24.000000|0|

TABLE:

create table T1 (

C1 numeric(12) null,

C2 varchar(8) null,

C3 numeric(12) null,

C4 varchar(8) null,

C5 date null,

c6 timestamp null,

C7 timestamp null,

C8 numeric(12) null)

LOAD TABLE T1 (C1, C2, C3, C4, C5 DATE ('MM/DD/YYYY'), FILLER('|'), C6 DATETIME('MM/DD/YYYY hh:nn:ss.ssssss'), FILLER('|'), C7 DATETIME ('MM/DD/YYYY hh:nn:ss.ssssss'), C8, FILLER('|')) from '/file.txt' ESCAPES OFF STRIP OFF DELIMITED BY '|' MESSAGE LOG '/msg.LOG' ROW LOG '/rowlog.LOG' ONLY LOG ALL;

The table is loaded, but the last column is null. In the file, the last column is number 0(zero).

*****************************************

In another test:

FILE(Without the | (pipe) in the end of the line)

4762613000|00131002|5600| |01/01/1970|10/03/201409:40:57.000000|10/03/2014 10:14:24.000000|0

4762613001|00131002|5601| |01/01/1970|10/03/201409:43:46.000000|10/03/2014 10:14:24.000000|0

4762613002|00131002|5605| |01/01/1970|10/03/201409:47:25.000000|10/03/2014 10:14:24.000000|0

LOAD TABLE T1 (C1, C2, C3, C4, C5 DATE ('MM/DD/YYYY'), FILLER('|'), C6 DATETIME ('MM/DD/YYYY hh:nn:ss.ssssss'), FILLER('|'), C7 DATETIME ('MM/DD/YYYY hh:nn:ss.ssssss'), C8) from '/file.txt' ESCAPES OFF STRIP OFF DELIMITED BY '|' MESSAGE LOG '/msg.LOG' ROW LOG '/rowlog.LOG' ONLY LOG ALL;

Does not return error, but does not load the table.

Thanks!

Attachments

numeric.png (7.9 kB)