Question

3
Replies
91
Views
Arjan Maus (ArjanM04)
Achmea

Achmea
NL
ArjanM04 Member since 2014 44 posts
Achmea
Posted: February 23, 2017
Last activity: February 24, 2017
Posted: 23 Feb 2017 4:53 EST
Last activity: 24 Feb 2017 6:34 EST
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

System Administration Installation and Deployment Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.