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 [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.
