DB2 connection Issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

DB2 connection Issue

Suresh kumar

Hi All,

 

We are getting the following  error when we try to attempt execute select statements in DB2.

 

[IBM][CLI Driver] CLI0122E  Program type out of range. SQLSTAT E=HY003

 

But the same sqls are working second time. This is happening in VW7.4.1 installed in RHEL with a 32 bit DB2 client.

 

Thanks in advance,

Suresh


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: DB2 connection Issue

Wallen, David

Hi Suresh,

 

I was curious and found this possible description for your error message:

“A numeric or string range error occured. Ensure that the capacity of the numeric or string column is sufficient to store the specified value the persistent object is attempting to store.”

 

Since the problem doesn’t seem obvious, it might help if you post the actual SQL that fails, along with the subsequent SQL that doesn’t fail, including any bound values. Perhaps the first SQL had a nil bound value, which defaults to String type in VW. Also, VW 7.4.1 is pretty old, so you could try the latest VW release and see if that works, for reference.

-Dave

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Suresh Kumar
Sent: Wednesday, March 20, 2013 8:04 AM
To: [hidden email]
Subject: [vwnc] DB2 connection Issue

 

Hi All,

 

We are getting the following  error when we try to attempt execute select statements in DB2.

 

[IBM][CLI Driver] CLI0122E  Program type out of range. SQLSTAT E=HY003

 

But the same sqls are working second time. This is happening in VW7.4.1 installed in RHEL with a 32 bit DB2 client.

 

Thanks in advance,

Suresh


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc