Conversion Of DB2 Task Crashes With Fields With DEFAULT Constraint Set To X'00' (Doc ID 1508098.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Tuxedo Application Runtime Workbench - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

The execution of the Conversion DB2 task in the Tuxedo ART workbench fails if there is any DDL sentence with the following DEFAULT constraint:
FIL CHAR (5) NOT NULL WITH DEFAULT X'0000000000'

Warning: unknown rule SQL-TRANSLATOR::SQL-REMOVE-QUERYNO in APPLIES-MAP
Fatal error while translating schema DESV

Error: "00" is not of type CHARACTER.

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