Does anyone know how to pass DB2 command(s) via a cfquery?
I've been tasked with getting a SQL query into Coldfusion
that uses - what looks to me - like a native DB2 command. (The DB2
EXPORT command takes data specified from a query and writes a
formatted file.) Specifically, I need to pass a query via
<cfquery> that looks something like:
EXPORT TO file.out
OF DEL MODIFIED BY STRIPLZEROS
select statement here
I'm kinda thinking that if you know how to "escape" the
native commands in a cfquery that might work, but for now when I
pass the above query it errors out on me.