I just upgraded to H2 1.3, and one of the features which most
interested me was the lack of a temporary file when doing "Select from
CSVread". However, I am still seeing one being created; is there a
switch, setting, or option I need to explicitly set?
My code looks like this:
CREATE TABLE Sample_80_to_85_2006_02Test3(ACTIVITYDT VARCHAR(7),LOANID
VARCHAR(40),DEALID VARCHAR(40),ACTUALBALANCE DECIMAL(20,2),[[A whole
lot deleted]] ROW_ID IDENTITY )AS SELECT
coalesce(ACTIVITYDT,''),coalesce(LOANID,''),coalesce(DEALID,''),coalesce(ACTUALBALANCE,0.0),[[even
more deleted]],coalesce(MSA_HPI,0), NULL from CSVREAD ('C:\VARisk
Cases\First Lien Model
Bug\\Sample_80_to_85_2006-02.csv',NULL,NULL,char(44))
--
=======================
Personal Blog: http://www.xanga.com/lizard_sf
Facebook: http://www.facebook.com/lizard_sf
MrLizard: Gaming and Geekery: http://www.mrlizard.com
--
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.
