Hi, Could you post the complete error message including error code and stack trace please?
Regards, Thomas On Mon, Dec 6, 2010 at 11:49 PM, Kent_Andrews <[email protected]> wrote: > 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. > > -- 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.
