Hi Thomas,
I am running H2 embedded within Pentaho (PDI), the error is listed
below.
I'm not certain which version of H2.jar they are shipping with the PDI
ver 3.2 at this time.
ERROR 07-12 16:58:28,634 - 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/
20101116/ECX_Rollups_p2.dat',NULL,NULL,'|')
Syntax error in 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/
20101116/ECX_Rollups_p2.dat',NULL,NULL,'|') [42000-46]
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.
