BTW ....
Error looks like:
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/
20101119/ECX_Rollups_p2.dat',NULL,NULL,'|'))
So it doesn't like the AS part "AS[*]" is where it shows the error in
the syntax.
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.
