Question

3
Replies
86
Views
ArjanM04 Member since 2014 39 posts
Achmea
Posted: February 23, 2017
Last activity: February 24, 2017
Closed

AES Upgrade 7.2 database issues

Hi,

I am upgrading AES to level 7.2

When importing I'm asked to update the database.

One of the statements results in an error..

ALTER TABLE PEGA_DATA.pegaam_action_work ADD COLUMN "CURRENTWEEKKPI" DECIMAL (32, 9); ALTER TABLE PEGA_DATA.pegaam_action_work ADD COLUMN "LASTWEEKKPI" DECIMAL (32, 9);

Error: SQL0604N The length, precision, or scale attribute for column, distinct type, structured type, array type, attribute of structured type, routine, cast target type, type mapping, or global variable "DECIMAL (32, 9)" is not valid. SQLSTATE=42611 (State:42611, Native Code: FFFFFDA4)

We are running on DB2 V10.

What's going wrong?

Kind regards,

Arjan Maus

Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn