> I'm using an ODBC data connection to an informix database. The ODBC
> is my source and SQL is my destination. In the data pump, I can query
> the data using literals in the where clause for a date range, but when
> I try to use a variable, I receive a ODBC/Informix syntax error. I
> need to extract data from this source every monday for the previous
> weeks data. I also tried writing a Dynamic SQL statement, the
> statement is good, but when I execute it on the ODBC connection, I
> receive the same syntax error.
>
> Anyone have any Idea how I can do this.
>
> Thanks.
>