I am specifying a user defined query like
Code: Select all
"SELECT COL1,COL2 FROM TABLE WHERE IN COL1 IN (111,112,113)"
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
What has gone wrong here?
Moderators: chulett, rschirm, roy
Code: Select all
"SELECT COL1,COL2 FROM TABLE WHERE IN COL1 IN (111,112,113)"
Try this,sb2212 wrote:Code: Select all
"SELECT COL1,COL2 FROM TABLE WHERE IN COL1 IN (111,112,113)"
What has gone wrong here?
Code: Select all
"SELECT COL1,COL2 FROM TABLE WHERE COL1 IN (111,112,113)"
Code: Select all
select col1,col2 from table where col1 in (111,112,113)