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] <javascript:>>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] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> 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.
