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.
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.