db2 error

Questionsdb2 error
germanmary asked 4 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

3 Answers
germanmary answered 4 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 4 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.

Your Answer

0 + 8 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!