Direct control of system names for global variables
The optional FOR SYSTEM NAME clause has been added to the CREATE VARIABLE SQL statement.
The name provided in the FOR SYSTEM NAME clause must be a valid system name and cannot be qualified. The first name provided for the object cannot be a valid system name.
Use the FOR SYSTEM NAME clause to achieve direct control over the service program (*SRVPGM) that is created when the CREATE VARIABLE SQL statement is executed.
See the SQL Reference for details: CREATE VARIABLE
CREATE OR REPLACE VARIABLE TOYSTORE.GV_EMPLOYEE_NUMBER FOR SYSTEM NAME GVEMPNO CHAR(6)
DEFAULT (select EMPNO from TOYSTORE.vemp where USER_PROFILE_NAME = USER);
13 January 2020