#8104: SQLExport is not performing variable substituion

SachinPrakash reported 2012-12-19T21:49:05Z · aquaclusters.josekibold last modified 2013-01-08T18:25:19Z

Dev	funfun
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	App - FluidShell - Command
Version	13.0

To reproduce this issue:

declare -x CumExecQty="column1"

select ${CumExecQty} from table1

sqlexport -f excel2007 -o output.xlsx

You will get back an error message w/ something like:

java.sql.SQLException: JZ0S8: An escape sequence in a SQL Query was malformed: '{CumExecQty}'.

All Comments (2) Change History

funfun 2012-12-19T23:15:12Z

\sqlexport did not perform command line substitution when processing the query retrieved from the SQL Buffer. Fixed, SVN r30680.

aquaclusters.josekibold 2013-01-08T18:25:19Z

Verified using ADStudio 13 Beta 2, the variables are substituted now when using sqlexport.

Closed.