RE: Numeric value out of range

Sap DB wrote: 
> 
> I have got troubles with an update using parameter and negative value:
> 
> 
> 
> running the following statement
> 
> UPDATE DBM350_SM SET StatusCode=-2, DIST_FILE=?, 
> DIST_NUM=DIST_NUM+1 WHERE
> MSN=30 AND (DIST_OWNER IS NULL) AND DIST_NUM=11
> 
> I got the message "Numeric value out of range;-3019 POS(1) Invalid
> exponent."
> 

May I ask for some more info:
Are there trigger on top of this table?
Please provide the vtrace according to
http://sapdb.2scale.net/moin.cgi/VTrace
Do the updates below work correctly even if the additional
AND (DIST_OWNER IS NULL) AND DIST_NUM=11
(part of the update above) are in?
I can't believe that they will make some difference, but
it is even hard to believe what could cause the -3019 above.

Elke
SAP Labs Berlin

> 
> I have tried the same statement with a positive value for 
> StatusCode and it
> works, and I have tried a statement without DIST_FILE and it works.
> 
> NOK--> UPDATE DBM350_SM SET StatusCode=-2, DIST_FILE=?, 
> DIST_NUM=DIST_NUM+1
> WHERE MSN=30
> 
> OK--> UPDATE DBM350_SM SET StatusCode=2, DIST_FILE=?, 
> DIST_NUM=DIST_NUM+1
> WHERE MSN=30
> 
> OK--> UPDATE DBM350_SM SET StatusCode=-2, DIST_NUM=DIST_NUM+1 
> WHERE MSN=30
> 
> 
> 
> I'm using the ODBC driver build 027-123-048-452
> 
> the table is create like : CREATE TABLE DBM350_SM (MSN SERIAL 
> PRIMARY KEY,
> StatusCode INTEGER, DIST_FILE LONG BINARY, DIST_NUM INTEGER)
> 
> 
> 
> If someone has any idea...
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>