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
5079 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

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers IBM,

Can you search give an array in the WHERE clause of a db2 query?

1 Answers

What is concurrency?

0 Answers

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers IBM,

What are the various data types available in db2?

0 Answers

Define check constraint.

0 Answers

what is the use of commit ? and what is the syntax?

2 Answers Deloitte,

How to select the duplicate rows from a table?

4 Answers

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers IBM,

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers UST,

What is an inner join, and an outer join ?

1 Answers CTA,

what is main use of table space and index object? please its urgent

5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

For more DB2 Interview Questions Click Here