The CREATE statment is stored in the SYSIBM.SYSVIEWS

Once you create a view, where would information about the
view be stored?

Question Posted / s

Answer Posted / s

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a db2 tablespace?

1046

What are the 2 sqlcodes that are returned?

1177

What is a db2 collection?

1022

What is the use of commit in db2?

1060

Differentiate between cs and rr isolation levels? Where do you specify them?

1050

Explain db2.

1016

What is iseries database?

1036

What are the different types of base tables?

1072

What is db2 stogroup?

1145

What is the cobol picture clause of the db2 data types date, time, timestamp?

1044

What is db2 and what is the use of db2 optimizer?

1035

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1027

What kind of database is db2?

1023

What is explain in db2?

1002

What is dbrm?

1087