3 Replies Latest reply on Dec 14, 2012 12:11 PM by meNitin

    Database Lookup error with DB2 in ODC

      Hi all,

      I have created one database lookup profile with DB2 database in ODC ,It is created successfully,but while indexing it gives the error: *[[IBM] [system i access ODBC driver][DB2 fot i5/OS]SQL 0206- column or global variable not found.[Error in EDO - ExecSearch on line 86]]*

      While creating the database lookup profile,I have given the following details :
      OLE DB Provide : Microsoft OLE DB provide for ODBC drivers and appropriate datasource name ,username and password.

      Please tell me what I am missing??
      How to remove this error??

      Thanks in advance.