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 the physical storage length of date data type?

1307

What is the max length of sqlca?

1270

What is with ur in db2?

1384

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1246

On which levels locks can be applied?

1204

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1222

How can we retrieve the total number of records in RPG & CLLE?

707

define clustering index.

1070

What is blu acceleration in db2?

1129

What is a bind in db2?

1105

What is view db2?

1131

Explain db2.

1087

What is declare cursor?

1169

What is db2 look?

1077

Explain packages.

1171