11 July,2011 by Tom Collins
"How to do a DB2 list schemas ?"
db2 connect to my_database
select schemaname from syscat.schemata
If you want to connect to another schema - read DB2 SET CURRENT SCHEMA
The recordset is something like :
DB2 SET CURRENT SCHEMA - DBA DB2
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |