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

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

Using the LGRANT line command in RC/Query for Db2 for z/OS (RCQ) to grant authorities to several userids and receive an SQL-107. 

Resolution

Starting with the 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.