By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

CLI0112E Error in assignment

P: n/a
I was using a DB2 v7 database with my application. It was working fine.

Now, I want to upgrade to DB2 v8.
With the same table description, and exactly the same statement from my
application, I receive a message "CLI0112E Error in assignment.
SQLSTATE=22005"

Have you an idea in which way should I search ?
(databases settings regarding language, country, code page... are the same,
and the OS too)

EM
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Could you post the table description along with the statement you are
trying to use!

Nov 12 '05 #2

P: n/a
Le 19 May 2005 01:04:53 -0700, Shyam Peri a écrit :
Could you post the table description along with the statement you are
trying to use!


CREATE TABLE WETIENNE.VEFIL050 (TVA_Catégorie_de_TVA SMALLINT NOT
NULL,TVA_TAUX_de_TVA FLOAT NOT NULL,TVA_NOM_de_TVA CHAR(70) NOT
NULL,TVA_code_tte_langue INTEGER NOT NULL)

CREATE UNIQUE INDEX WETIENNE.Categorie ON WETIENNE.VEFIL050
(TVA_Catégorie_de_TVA ASC)
INSERT INTO
VEFIL050(TVA_Catégorie_de_TVA,TVA_TAUX_de_TVA,TVA_ NOM_de_TVA,TVA_code_tte_langue)VALUES(?,?,?,?)
with Value :
1,12.12,'Test',1

But when I check the trace log I have from my tool, I got 12,12 instead of
12.12.
I assume that the problem comes from that, but with DB2 v7, with exactly
the same statement (create and insert) it works fine.

In fact, it's as if my v8 database doesn't recognize the ',' characters.

've tried to install DB2 in english (US) instead of french (FR) but the
problem is the same. OS is in french.

thanks,
EM
Nov 12 '05 #3

P: n/a
Le Wed, 18 May 2005 14:15:21 +0200, Wetienne a écrit :
I was using a DB2 v7 database with my application. It was working fine.

Now, I want to upgrade to DB2 v8.
With the same table description, and exactly the same statement from my
application, I receive a message "CLI0112E Error in assignment.
SQLSTATE=22005"

Have you an idea in which way should I search ?
(databases settings regarding language, country, code page... are the same,
and the OS too)

EM


Hi,

In fact my problem could be due to a problem described in APAR #IY66088
(http://www-1.ibm.com/support/docview...id=swg1IY66088)
I haven't any access to this locked database. Can someone help me ?

Thanks,
EM

Nov 12 '05 #4

P: n/a
Le Wed, 25 May 2005 15:07:34 +0200, Wetienne a écrit :
Le Wed, 18 May 2005 14:15:21 +0200, Wetienne a écrit :
I was using a DB2 v7 database with my application. It was working fine.

Now, I want to upgrade to DB2 v8.
With the same table description, and exactly the same statement from my
application, I receive a message "CLI0112E Error in assignment.
SQLSTATE=22005"

Have you an idea in which way should I search ?
(databases settings regarding language, country, code page... are the same,
and the OS too)

EM


Hi,

In fact my problem could be due to a problem described in APAR #IY66088
(http://www-1.ibm.com/support/docview...id=swg1IY66088)
I haven't any access to this locked database. Can someone help me ?

Thanks,
EM


I got it !
Now I know what this kind of APAR is locked :
no solution, no fix !!!!!
except a "Local fix : Use a period as the decimal separator (not a comma)
for the values being inserted."
That's mean change your local settings !!!! the other solution is to change
our database...

EM
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.