Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5061 Views
- I also Faced
- E-Mail Answers
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 |
Why do we use cursor?
What is page size in db2?
What is meant by union and union all?
Is the primary key a clustered index?
how can u retrieve the data from null values using applicaion program.
what is Runstats? Whem will u choose to runatats?
What is copy pending and check pending in db2?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is the default page size of buffer pools?
What is a page?
What is the picture clause of null indicator variable?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
COBOL 
