germanmary asked 9 years ago
hi sir,
i am getting the following issue
please help me to get rid of the problems
Couldn't execute query. [IBM][CLI Driver][DB2/NT64] SQL0206N "CUSTID" is not valid in the context where it is used. SQLSTATE=42703 SQLCODE=-206 – SELECT count(*) as c FROM (SELECT * FROM ADMIN."mrkt_customermast" WHERE 1=1 AND ( custid LIKE '%5%' )) pg_tmp
i am getting this error while
trying to enter data in primary id field
Abu Ghufran answered 9 years ago
Refer following:
http://stackoverflow.com/questions/11104267/existing-db2-column-reported-as-not-being-a-column-of-the-table
http://stackoverflow.com/questions/4831514/db2-details-42s22ibmcli-driverdb2-sql0206n-colname-is-not-valid-in-th
http://www-01.ibm.com/support/docview.wss?uid=swg21236040
germanmary answered 9 years ago
Thank you sir
this error comes when i am trying to search in php grid id field for other text it is working
Abu Ghufran answered 9 years ago
Try updating the column with complete name e.g. table.field,
$col["dbname"] = 'table.field";
It would then use complete name in WHERE clause.
