Hi, Yes, you should try again with a recent version (I don't know what version of H2 you are using).
Regards, Thomas On Fri, Aug 23, 2013 at 5:46 PM, sc8132 <[email protected]> wrote: > I'm not sure? I'm using it within a Quantrix database. I've tried numerous > combos too. Should I download the newest version of H2? > > Thanks! > > > On Friday, August 23, 2013 8:06:08 AM UTC-7, Thomas Mueller wrote: > >> >> Hi, >> >> It works for me, what version of H2 are you using? What I tried is: >> >> CALL CSVWRITE('~/temp/test.csv', >> 'SELECT 1 Hello, ''Hello'' World FROM dual', >> 'fieldDelimiter= writeColumnHeader=false') >> >> Regards, >> Thomas >> >> >> On Fri, Aug 23, 2013 at 3:08 PM, sc8132 <[email protected]> wrote: >> >>> Hello, >>> >>> Hopefully someone can enlighten me, as I am stumped... >>> >>> Here is my working code: >>> >>> CALL CSVWRITE('\\fileLocation.'|| FORMATDATETIME (CURRENT_TIMESTAMP(),'* >>> *MMddyyyyHHmm ', 'PDT') || '.csv', >>> 'SELECT "Date", "ServiceType", "Value" FROM "PUBLIC"."Volumes"') >>> >>> I would like to add something that tells it to exclude the header when >>> exporting... I believe this is the statement: >>> 'fieldDelimiter= writeColumnHeader=false') >>> >>> When I add it to my code, it does not work. This is how I added it: >>> CALL CSVWRITE('\\fileLocation.'|| FORMATDATETIME (CURRENT_TIMESTAMP(),'* >>> *MMddyyyyHHmm ', 'PDT') || '.csv', >>> 'SELECT "Date", "ServiceType", "Value" FROM "PUBLIC"."Volumes"', >>> 'fieldDelimiter= writeColumnHeader=false') >>> >>> When I've used it in a different type of code, without the explicit >>> naming of columns, it works. Is there a conflict because of that explicit >>> title sort order? If so, is there any work around for that? >>> >>> Thanks! >>> Sherry >>> >>> -- >>> 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...@**googlegroups.com. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at >>> http://groups.google.com/**group/h2-database<http://groups.google.com/group/h2-database> >>> . >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >> >> -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
