Hi Thomas,
Getting better error messages using latest jar however.
ERROR 07-12 17:44:17,559 - SQL 1 - An error occurred executing this
job entry :
Couldn't execute SQL: CREATE TABLE DST_CUST (ACCTCORP VARCHAR,
LPAD_ACCTCORP VARCHAR, HOUSE VARCHAR, LPAD_HOUSE VARCHAR, CUST
VARCHAR, LPAD_CUST VARCHAR, SRC_ACCT_NUM VARCHAR, SRC_HOUSE_KEY
VARCHAR, SERV VARCHAR, DEL_SYS VARCHAR, ADDRESSABLE VARCHAR,
PRODUCT_MAPPING_SERVICE VARCHAR, SRC_ACCT_NUM_1 VARCHAR,
SRC_ACCT_NUM_2 VARCHAR, BILLING_ACCOUNT_NUMBER VARCHAR, IMS_FLG
VARCHAR, WAC_FLG VARCHAR, HBX_FLG VARCHAR, FPL_FLG VARCHAR, TRK_FLG
VARCHAR, XHS_FLG VARCHAR, T2W_FLG VARCHAR, DIG_FLG VARCHAR, CDV_FLG
VARCHAR, GDS_TTS_FLG VARCHAR, XCV_FLG VARCHAR, XSS_FLG VARCHAR,
VIDEO_PROD_FLG VARCHAR, HSD_PROD_FLG VARCHAR, TELE_PROD_FLG VARCHAR,
WIRELESS_AIRCARD_FLG VARCHAR, CUST_CLASS_FLG VARCHAR) AS SELECT * FROM
CSVREAD('/u01/users/kandre5171c/projects/tts_remedy_feed_pdi/data/
20101119/ECX_Rollups_p2.dat',NULL,NULL,'|')
Column count does not match; SQL statement:
CREATE TABLE DST_CUST (ACCTCORP VARCHAR, LPAD_ACCTCORP VARCHAR, HOUSE
VARCHAR, LPAD_HOUSE VARCHAR, CUST VARCHAR, LPAD_CUST VARCHAR,
SRC_ACCT_NUM VARCHAR, SRC_HOUSE_KEY VARCHAR, SERV VARCHAR, DEL_SYS
VARCHAR, ADDRESSABLE VARCHAR, PRODUCT_MAPPING_SERVICE VARCHAR,
SRC_ACCT_NUM_1 VARCHAR, SRC_ACCT_NUM_2 VARCHAR, BILLING_ACCOUNT_NUMBER
VARCHAR, IMS_FLG VARCHAR, WAC_FLG VARCHAR, HBX_FLG VARCHAR, FPL_FLG
VARCHAR, TRK_FLG VARCHAR, XHS_FLG VARCHAR, T2W_FLG VARCHAR, DIG_FLG
VARCHAR, CDV_FLG VARCHAR, GDS_TTS_FLG VARCHAR, XCV_FLG VARCHAR,
XSS_FLG VARCHAR, VIDEO_PROD_FLG VARCHAR, HSD_PROD_FLG VARCHAR,
TELE_PROD_FLG VARCHAR, WIRELESS_AIRCARD_FLG VARCHAR, CUST_CLASS_FLG
VARCHAR) AS SELECT * FROM CSVREAD('/u01/users/kandre5171c/projects/
tts_remedy_feed_pdi/data/20101119/ECX_Rollups_p2.dat',NULL,NULL,'|')
[21002-147]
I have checked that the columns line up with the data file being used
to import. I did an import using Excel and the data lines up with the
columns. There is some empty data/columns including the vary last one.
Would that be an issue?
Thanks
Kent
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
