How to do a DB2 list schemas ?
Step 1 – Connect to the database
db2 connect to my_database
Step 2 – Execute this query
select schemaname from syscat.schemata
The recordset is something like :
Author: Jack Vamvas
db2 connect to my_database
select schemaname from syscat.schemata
The recordset is something like :
Author: Jack Vamvas
Leave a Reply