Retrieving catalog information about sequences

The SYSIBM.SYSSEQUENCES and SYSIBM.SYSSEQUENCEAUTH tables contain information about sequences.

Procedure

Begin general-use programming interface information.

To obtain information about sequences:

Query the SYSIBM.SYSSEQUENCES or SYSIBM.SYSSEQUENCEAUTH table.

To retrieve the attributes of a sequence, issue this query:

SELECT *
  FROM SYSIBM.SYSSEQUENCES
  WHERE NAME = 'MYSEQ' AND SCHEMA = 'USER1B';

Issue this query to determine the privileges that user USER1B has on sequences:

SELECT GRANTOR, NAME, DATEGRANTED, ALTERAUTH, USEAUTH
  FROM SYSIBM.SEQUENCEAUTH
  WHERE GRANTEE = 'USER1B';

End general-use programming interface information.