Fast Export Script Error, what is wrong ?

Database

Fast Export Script Error, what is wrong ?

my input data is like this, I fakes the data of course :-)

 

cust_key|cust_journey
25487|Retained
659874|Lapsed
365874|Lapsed

 

 

here is the error that I am getting:

 

**** 10:01:55 Session count 6 returned by the DBS overrides
              user-requested session count
**** 10:02:00 Number of FastLoad sessions connected = 6
**** 10:02:00 FDL4808 LOGON successful
**** 10:02:00 RDBMS error 3706: Syntax error: expected something
              between the word 'table_name' and
              the 'WITH' keyword.

 

here is my script:

 

 

 

 

.logmech ldap

.logon database/USERID,PASS; 

drop table table_name;

CREATE TABLE table_name
( cust_key INTEGER,
  cust_journey VARCHAR (30)
) primary index(cust_key);

SET RECORD VARTEXT "|";

DEFINE cust_key (VARCHAR(30)), cust_journey (VARCHAR(30)) FILE = inputfile.txt;
     
show;

BEGIN LOADING table_name;
ERRORFILES table1, table2
CHECKPOINT 50000
INDICATORS;

INSERT INTO   table_name (
    cust_key,
    cust_journey
    ) 
      VALUES (  
     :cust_key, 
     :cust_journey
     ); 

END LOADING;  

LOGOFF;
QUIT;

 

 

 

 

 

 

 

 

1 REPLY

Re: Fast Export Script Error, what is wrong ?

I have adjusted the BEGIN LOADING to:

 

BEGIN LOADING table1 errorfiles errortbl1, errortbl2;

INSERT INTO table1 (
    cust_key,
    cust_journey
    )
      VALUES (  
     :cust_key,
     :cust_journey
     );

END LOADING;  

LOGOFF;
QUIT;

 

 

now I get this error:

 

**** 10:37:36 Number of recs/msg: 988
**** 10:37:36 Starting to send to RDBMS with record 1
**** 10:37:36 Error on piom GET ROW: 60, Text: Column length error, row
              not returned !ERROR! Delimited Data Parsing error: Column
              length overflow(s) in row 208 for column 2
**** 10:37:36 Error at record number 208