0 Replies Latest reply on Aug 6, 2007 12:23 PM by rich.leach

    passing DB2 commands via cfquery

    rich.leach
      Hi-

      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:

      <cfquery...>
      EXPORT TO file.out
      OF DEL MODIFIED BY STRIPLZEROS
      SELECT
      select statement here
      </cfquery>

      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.

      Anyone?

      Thanks,

      Rich