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??