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

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

Question Posted / guest

1 Answers
5137 Views
I also Faced
E-Mail Answers

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

Answer / s

The CREATE statment is stored in the SYSIBM.SYSVIEWS

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB2 Interview Questions

What db2 400?

0 Answers

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

0 Answers

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers

What is a DB2 bind?

1 Answers Logica CMG,

What is the purpose of the QUIESE Utility?

1 Answers

What is the syntax for creating a table in the db2 database?

0 Answers

What is db2 command?

0 Answers

Where can you declare a cursor in a cobol-db2 program?

0 Answers

What are the two types of logging in the db2 database? Explain them.

0 Answers

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers

How do you check for a null value in a db2 column?

2 Answers

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers

For more DB2 Interview Questions Click Here