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

What is precompiler in db2?

1007

What are the contents of dclgen?

1100

Explain db2.

1020

What is the result of open cursor statement?

1073

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

1086

Which components manage deadlocks in db2?

1059

Which isolation level provides maximum concurrency?

1149

what are bind concepts in db2 cobol?

1085

What is the use of commit in db2?

1065

Can you use max on a char column?

1087

What kind of database is db2?

1028

What is a buffer in memory?

1053

What is rebind in db2?

1046

How to access db2 tables in mainframe?

1047

What is the difference between spufi and qmf?

1120