LGRANT line command in RC/Query results in an SQL-107.

Document ID : KB000053962
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

I am using the LGRANT line command in RC/Query to grant authorities to several userid?s and receive an SQL-107. What causes this error and how to resolve it?

Solution:

With r11.5 release, the userid fields are expanded to handle userid's longer than 8 characters, and do not allow free-form entry of the userid's. So each "TO" line on the "Line Grant/Revoke" panel is now used for a separate ID.

The SQL-107 occurs if you specify multiple userid's on the same line on the LGRANT panel.

DSNT408I SQLCODE = -107, ERROR:  THE NAME "xxx, yyy"
          IS TOO LONG.  MAXIMUM ALLOWABLE SIZE IS   8
 DSNT418I SQLSTATE   = 42622 SQLSTATE RETURN CODE
 DSNT415I SQLERRP    = DSNHSMUD SQL PROCEDURE DETECTING ERROR
 DSNT416I SQLERRD    = 2604  0  0  -1  57  0 SQL DIAGNOSTIC INFORMATION
 DSNT416I SQLERRD    = X'00000A2C'  X'00000000'  X'00000000'
          X'FFFFFFFF'  X'00000039'  X'00000000' SQL DIAGNOSTIC
          INFORMATION
 BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.
RETCODE =     8

Where xxx, yyy are the grantees.

To resolve the SQL-107 error, enter one userid per line on the "TO" field.