#8104: SQLExport is not performing variable substituion | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Sachin Prakash

SachinPrakash reported Dec 19, 2012 · aquaclusters.josekibold last modified Jan 8, 2013

SQLExport is not performing variable substituion

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

go

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 Change History (2)

Fun Fun

funfun Dec 19, 2012

Field	Old Value	New Value
Fixed Build		trunk/30680
Resolution		Fixed
Resolved Date		Dec 19, 2012 11:15 PM
Status	New	Resolved

Joseki Aquaclusters Team

aquaclusters.josekibold Jan 8, 2013

Field	Old Value	New Value
Status	Resolved	Closed

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017