I try with this query
SELECT 'icetea--NagLogApplicationError--' || SPOOLER_ID || '--critical--JOB
' || Job_NAME || ' status ERROR at time ' || END_TIME || '--ROC' FROM
SCHEDULER_HISTORY WHERE JOB_NAME = 'SMS_Test' AND ERROR = 'TRUE'
the result is satisfied but when I try to use CSVWRITE it's syntax error
the query is
CALL CSVWRITE('nag_log.csv', 'SELECT 'icetea--NagLogApplicationError--' ||
SPOOLER_ID || '--critical--JOB ' || Job_NAME || ' status ERROR at time ' ||
END_TIME || '--ROC' FROM SCHEDULER_HISTORY WHERE JOB_NAME = 'SMS_Test' AND
ERROR = 'TRUE'', 'charset=UTF-8 fieldSeparator=||');
and the error message is
Syntax error in SQL statement "CALL CSVWRITE('nag_log.csv', 'SELECT
'ICETEA[*]
;
"; expected "[, ::, *, /, %, +, -, ||, ~, !~, NOT, LIKE, REGEXP, IS, IN,
BETWEEN, AND, OR, ,, )"; SQL statement:
CALL CSVWRITE('nag_log.csv', 'SELECT 'icetea--NagLogApplicationError--' ||
SPOOLER_ID || '--critical--JOB ' || Job_NAME || ' status ERROR at time ' ||
END_TIME || '--ROC' FROM SCHEDULER_HISTORY WHERE JOB_NAME = 'SMS_Test' AND
ERROR = 'TRUE'', 'charset=UTF-8 fieldSeparator=||'); [42001-175] <#>
42001/42001 (Help)
<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c42001>
What I missed the point? Thank you for your help.
Phamorn Hongsawat
On Tuesday, August 5, 2014 1:36:51 AM UTC+7, Thomas Mueller wrote:
>
> Hi,
>
> You could use a "java.util.Writer" of course, possibly in a user defined
> function.
>
> Or you could still use the CSV tool, but disable the header, put
> everything in one single column, and use a formula for that column (for
> example "select 'Customer name ' || name || ' have a salary ' || salary
> from tableName"). But you would need to set the CSV options correctly (as
> for quoting and escaping).
>
> Regards,
> Thomas
>
>
>
> On Mon, Aug 4, 2014 at 10:12 AM, Phamorn Hongsawat <[email protected]>
> wrote:
>
>> I want to design output as a text file. Suppose I have a table with Name
>> and Salary row like this
>>
>> Name | Salart
>> _________________
>>
>> Peter | 20000
>> _________________
>>
>> Michael | 30000
>>
>> I knew about CSVWRITE function but I want a text file like this
>> (customize the sentence)
>>
>> Customer name Peter have a salary 20000
>> Customer name Michael have a salary 30000
>> .
>> .
>> .
>>
>> Is it possible? If so, how can I deal with?
>>
>> --
>> 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/d/optout.
>>
>
>
--
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/d/optout.
