Hi,
Trying to run this and getting an error saying it doesn't like the
syntax:
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,'|');
Just curious is this the fastest way to create and load up a table?
Does this get skip or get past the "redo logs"?
Similar to a Bulk Load?
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.
