IP16.17 EIM Failing With DB2 Z/OS Error Due To SQL "OVERRIDING USER VALUE"

(Doc ID 2342449.1)

Last updated on DECEMBER 22, 2017

Applies to:

Siebel CRM - Version 16.17 [IP2016] to 16.18 [IP2016] [Release V16]
Information in this document applies to any platform.

Symptoms

On : 16.17 [IP2016] version, EIM

EIM inserts are failing with DB2 z/OS error after moving from 16.7 to 16.17.

DB2 offers a sql extension "Overriding user value" which can be applied to force the insert of the next free sequence, regardless which value originally is provided in the sub-select statement.

   See: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_insert.html


ERROR
-----------------------
SQL0109N The statement or command was not processed because the following clause is not supported in the context where it is used: "OVERRIDING USER VALUE". SQLSTATE=42601


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run an EIM import job on Siebel 16.17 with DB2 z/OS that involves a table column defined as GENERATED ALWAYS.

Changes

 

Cause

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