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

Answer Posted / s

The CREATE statment is stored in the SYSIBM.SYSVIEWS

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

986


How do I delete a column in db2?

862


What is null value in db2?

756


List down the data types in the db2 database.

814


What are the uses of db2 optimizer?

1035


What are the bind parameters ibm db2?

810


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2903


What is db2 look?

793


What is alias in db2?

800


What is the difference between spufi and qmf?

820


What is bind package and plan in db2?

803


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2115


What is scrollable cursor in db2?

799


What is with ur in db2?

1023


what is a corelated subquerry?

834