CLI0112E Error in assignment

[Wetienne]

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

[Shyam Peri]

Could you post the table description along with the statement you are
trying to use!

[Wetienne]

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

[Wetienne]

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

[Wetienne]

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