I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this?

Answer Posted / satish

select count(*) from sysibm.systables where creator='owner'

select * from sysibm.systables

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1824


What is cascading rollback?

889


What does sqlcabc has?

832


What is the maximum No of rows per page?

855


What is the use of dclgen in db2?

832


How does cobol compile db2 program?

844


What is the max length of sqlca?

1012


What is commit in db2?

836


What are the prerogatives?

833


What's The Error Code For Unique Index Voilation?

936


Highlight all the advantages that are attached to a package.

920


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2145


What is db2 connect?

840


What is the connection string to connect to the DB2 Database ?

895


Is ibm db2 open source?

859