Hints and tricks for Ibm (DB2 ZOs, EGL)

You have users in GROUP1 and GROUP2. In DB2 you have SELECT privileges on objects to GROUP1 and some administration (create sequence) privileges to GROUP2. If you would like to specify witch group you will use on create you mus do the folowing:

SET CURRENT SQLID = 'GROUP2';