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]
|