do a select on SYSIBM.SYSTABLES

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?

Question Posted / s

Answer Posted / s

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Define db2.

1071

Is db2 a mainframe database?

959

What do you mean by between and in? Is between inclusive of specified range values?

1053

Which component is responsible for processing sql statements and selecting access paths?

1093

Explain the benefits you can get from mainframe connect?

924

Define db2 and its databases?

1027

What do you mean by commit and rollback?

992

What is null indicator in cobol db2?

1008

What is dbrm?

1053

What are the benefits of using the db2 database?

1172

What is the difference between db2 and oracle?

1078

List some fields from sqlca?

1016

How do I add a column to an existing table in db2?

986

How and when does the db2 enforces the unique key?

1051

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1024