[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sb2212
Participant
Posts: 36
Joined: Mon Apr 28, 2008 1:22 am

[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22

Post by sb2212 »

I am building a simple job wherein I am using a DB2/UDB stage and linking it to a sequential file.
I am specifying a user defined query like

Code: Select all

"SELECT COL1,COL2 FROM TABLE WHERE IN COL1 IN (111,112,113)"
When I execute the query i get the following error and the job aborts.
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005

What has gone wrong here?
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Re: [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTAT

Post by gssr »

sb2212 wrote:

Code: Select all

"SELECT COL1,COL2 FROM TABLE WHERE IN COL1 IN (111,112,113)"

What has gone wrong here?
Try this,

Code: Select all

"SELECT COL1,COL2 FROM TABLE WHERE COL1 IN (111,112,113)"
RAJ
sb2212
Participant
Posts: 36
Joined: Mon Apr 28, 2008 1:22 am

Post by sb2212 »

sorry that was typo error from me.

it is

Code: Select all

select col1,col2 from table where col1 in (111,112,113)
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

Can you able to execute the query sucessfully in Command line in DB2?

I think the problem is from DB end!!!
RAJ
sb2212
Participant
Posts: 36
Joined: Mon Apr 28, 2008 1:22 am

Post by sb2212 »

Yes in the command line I am able to get the result.
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

The Problem is due to Datatype mismatch,

Check out this,

viewtopic.php?t=107217&highlight=SQLSTATE%3D22005
RAJ
sb2212
Participant
Posts: 36
Joined: Mon Apr 28, 2008 1:22 am

Post by sb2212 »

ya the problem is solved.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

HOW is the problem solved?

Was it that the data type of COL1 was not some kind of integer?

In any case please mark this thread as Resolved using the green button at the top.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply