define clustering index.
How to define the data items to receive the fetch items for the SQL?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What is a subselect? Is it different from a nested select?
How do I add a column to an existing table in db2?
What are the isolation levels possible ?
How do you Load a table ?? and what is Load replace ?
What is reorg in DB2
How do you stop a db2 database in linux?
What is the difference between dbm cfg and db cfg file in db2 ?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Can we insert update delete in view?
What is an instance in db2?