[Squirrel-sql-users] adding an date extension to a CSV file

[GWIN, I. <ig...@at...>]

     Hi all

I working  on adding an date extension to a CSV file. Below is sql statement I'm using

I receive and error message below.



example

@file '/tmp/customers'||Now()||'.csv' SELECT * FROM customers

   will write the result of 'SELECT * FROM customers' to

'/tmp/customers'||Now()-1||'.csv'


Beginning to write file: \tmp\customers
Error writing file '\tmp\customers': org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]||[*]Now(" at line 1, column 1.
Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...

Thanks
Ivory Gwin
Senior-System Engineer
AEIS IT - OMS/SDP/IOMIP
Phone:      773-628-8643
Cell:           847-217-0864
[cid:image001.jpg@01D600E8.129781A0]