Hi, > How can I customize the header of the output file?
For example wIth a "union" select. Regards, Thomas On Tue, Aug 5, 2014 at 10:01 AM, Phamorn Hongsawat <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > I found my mistake already while I read the SQL Grammar. > > Next is the result generated by the query have a header I don't want. > > How can I customize the header of the output file? For example > > _____A_____B_____C_____D > ___1| This result is queried at time xxxxxxx (xxxxxxx is current time > that query executed) > ___2| (this line is a result from query) > ___3| (this line is a result from query) > . > . > . > . > ___n| (this line is a result from query) > > > Thank you for your help. > > Phamorn Hongsawat > > On Tuesday, August 5, 2014 9:14:00 AM UTC+7, Phamorn Hongsawat wrote: >> >> 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] >> <#147a548ea7a40775_147a530394e0dee1_f2e5d222-d07c-4f6f-a617-c14627ff9ecd@googlegroups.com_> >> 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[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.
