CDXPatch for Not 'comma as decimal' Compliant Patches for DB2 Environment

(Doc ID 1086377.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 1.5.20.2 and later   [Release: 1.5 and later ]
Information in this document applies to any platform.

Goal


When attempting to apply the DB changes of the Patch 6642279, the following errors occurs.

INSERT INTO CI_MD_FLD
(FLD_NAME,BASE_FLD_NAME,DATA_TYPE_FLG,EXT_DATA_TYPE_FLG,SIGNED_SW,FLD_PRECISION,FLD_SCALE,FLD_VAL_CB,WORK_FLD_SW,OWNER_FLG)
VALUES ('APAY_METHOD_FLG ',' ','CHAR','FLG
','N',4,0,'CICPAPM8','N','CI ');



--ERROR: [IBM][CLI Driver][DB2] SQL0104N An unexpected token ",4" was found following "". Expected tokens may include: "MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS". SQLSTATE=42601


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms