DSXchange

Hi all,

I am facing problem with odbc stage.
In my job i am doing sparse lookup with ODBC stage and Lookup query is simple select query,but i am getting fatal error as

" [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]NUMBER OF HOST VARIABLES SPECIFIED <> NUMBER OF PARAMETER MARKERS."

with normal lookup its working fine,i am not getting what is the problem with sparse lookup.

If any one knows please help me

You have a mismatch between the number of parameter markers (the ?) and key columns in the stage. Can you post your 'simple select' and explain how you configured the stage?