SQL

Work with Licensed Programs

SELECT A.AUTL as user1, B.AUTL as user2
FROM (SELECT autl
      FROM QSYS2.AUTHORIZATION_LIST_USER_INFO
      WHERE user_name = 'profile_1')  A
FULL OUTER JOIN (SELECT autl
      FROM QSYS2.AUTHORIZATION_LIST_USER_INFO
      WHERE user_name = 'profile_2')  B 
ON A.AUTL = B.AUTL;

SELECT system_column_name, column_name, system_table_name, system_table_schema, data_type, length, numeric_scale, column_heading
FROM QSYS2.SYSCOLUMNS
WHERE table_name = 'USER_INFO' AND table_schema='QSYS2'

SELECT DATA_SIZE,SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA,NUMBER_ROWS, NUMBER_DELETED_ROWS              
       FROM QSYS2.SYSTABLESTAT                 
       WHERE SYSTEM_TABLE_SCHEMA = 'Library_name'
       ORDER BY NUMBER_DELETED_ROWS DESC       

SELECT system_table_member                                
FROM sysibm/syspstat
WHERE system_table_schema = 'LibraryName' AND system_table_name = 'FileName'