Sqlcode = -107 when creating views in G4DDVWS8 with DB2 v8 (Doc ID 452968.1)

Last updated on SEPTEMBER 07, 2010

Applies to:

Operating System Dependent Interface - Version: 1.2 to 1.2.1.4
IBM z/OS on System z

Symptoms

When Installing the TG4DB2 v10.2.0.3 and running the script thru DSNTEP2 G4DDVWS8, the following
error occured:

DSNT408I SQLCODE = -107, ERROR: THE NAME "CURRENT_CLIENT_ACCTNG" IS TOO LONG.
MAXIMUM ALLOWABLE SIZE IS 18
DSNT418I SQLSTATE = 42622 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHSMUD SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 2604 0 0 -1 1228 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000A2C' X'00000000' X'00000000' X'FFFFFFFF'
X'000004CC' X'00000000' SQL DIAGNOSTIC INFORMATION

This is being run with DB2 v8 COMPATIBILITY MODE.

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