My Oracle Support Banner

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

Last updated on JULY 16, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.