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?
Answers were Sorted based on User's Feedback
Answer / s
SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satish
select count(*) from sysibm.systables where creator='owner'
select * from sysibm.systables
Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of runstats in db2?
How does coalesce work?
What does DSNDB07 database do?
What is meant by index cardinality?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What are simple, segmented and partitioned table spaces ?
How do I change the column size in db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is coalesce in db2?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.