1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Database Lookup error with DB2 in ODC

Discussion in 'Oracle Webcenter Suite (formerly Oracle ECM)' started by YogitaM1, Dec 14, 2012.

  1. YogitaM1

    YogitaM1 Active Member

    Likes Received:
    Trophy Points:
    Navi Mumbai
    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.