Using SQL to query ADSM

• Once you have a table in mind, use COLUMNS to determine what is in that table.

• The COLUMNS table has the most specific information about what a particular ADSM database table contains.

• SELECT * FROM SYSCAT.COLUMNS WHERE TABNAME='tablename'

• Example:

  • SELECT * FROM SYSCAT.COLUMNS WHERE TABNAME='CONTENTS'

Vorherige Folie

Nächste Folie

Zurück zur ersten Folie

Graphik-Version anzeigen