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
- 4999 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 |
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What does db2 stand for?
How do you check for a null value in a db2 column?
What is a host variable?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Request to database but database is not available so what is was abend is raised?
What is the purpose of the WHENEVER statement?
B37 abend during spufi?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is difference between isnull and coalesce?
how to resolve -811 sqlcode .give clear explaination
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
COBOL 
