Hi Team, I am using CSVREAD function to dump data from csv into a table using below query.
INSERT INTO testdomain.`sale_data` (SELECT Column3,Column1,Column2 FROM CSVREAD('E:\Temp\nosqldb\saledata_1110.csv',null,'fieldSeparator=\, charset=UTF-8') LIMIT 0,40). Data got dumped into table but i am no longer able to delete the csv from file system. I tried running this query from a java program and through web console on windows machine. But I could not delete the file from file system. My h2 version is 1.3.76 . can someone please help me here. Thanks in advance. Satheesh -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1c9ac5d2-9351-4017-88c3-f8e8813f2e8cn%40googlegroups.com.