Which DB2 catalog tables are used to produce a list of
table column by table for all tables in a database?

Answer Posted / s

SYSIBM.SYSCOLUMNS

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of indexes?

750


Explain various types of locks in db2?

858


B37 abend during spufi?

1194


What are the various data types available in db2?

795


What is the syntax for FETCH in DB2 ?

868






What does db2 plan contain?

739


What types of tables are there in the db2 database?

765


What is the advantage in De-normalizing tables in DB2?

925


Mention the location where the output received from explain statement is stored.

829


Is db2 a mainframe database?

719


What is db2?

893


What is query_cache_limit?

721


What are host variables in db2?

791


How do you simulate the explain of an embedded sql statement in spufi/qmf?

818


What is dbrm? What it contains? When it will be created?

772