DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
sb2212
Participant



Joined: 28 Apr 2008
Posts: 36

Points: 235

Post Posted: Mon Feb 15, 2010 12:14 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 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

Group memberships:
Heartland Usergroup

Joined: 09 Jan 2009
Posts: 243
Location: India
Points: 1249

Post Posted: Mon Feb 15, 2010 12:17 am Reply with quote    Back to top    

sb2212 wrote:


Code:

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



What has gone wrong here?


Try this,


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

_________________
RAJ
Rate this response:  
Not yet rated
sb2212
Participant



Joined: 28 Apr 2008
Posts: 36

Points: 235

Post Posted: Mon Feb 15, 2010 12:22 am Reply with quote    Back to top    

sorry that was typo error from me.

it is

Code:

select col1,col2 from table where col1 in (111,112,113)
Rate this response:  
Not yet rated
gssr
Participant

Group memberships:
Heartland Usergroup

Joined: 09 Jan 2009
Posts: 243
Location: India
Points: 1249

Post Posted: Mon Feb 15, 2010 12:33 am Reply with quote    Back to top    

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

I think the problem is from DB end!!!

_________________
RAJ
Rate this response:  
Not yet rated
sb2212
Participant



Joined: 28 Apr 2008
Posts: 36

Points: 235

Post Posted: Mon Feb 15, 2010 12:39 am Reply with quote    Back to top    

Yes in the command line I am able to get the result.
Rate this response:  
Not yet rated
gssr
Participant

Group memberships:
Heartland Usergroup

Joined: 09 Jan 2009
Posts: 243
Location: India
Points: 1249

Post Posted: Mon Feb 15, 2010 12:49 am Reply with quote    Back to top    

The Problem is due to Datatype mismatch,

Check out this,

http://www.dsxchange.com/viewtopic.php?t=107217&highlight=SQLSTATE%3D22005

_________________
RAJ
Rate this response:  
Not yet rated
sb2212
Participant



Joined: 28 Apr 2008
Posts: 36

Points: 235

Post Posted: Mon Feb 15, 2010 12:53 am Reply with quote    Back to top    

ya the problem is solved.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54549
Location: Sydney, Australia
Points: 295797

Post Posted: Mon Feb 15, 2010 1:06 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours