Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with LOAD TABLE

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!

Former Member
Not what you were looking for? View more on this topic or Ask a question