Mention the location where the output received from explain statement is stored.
how do u update the faltfile into db2 table ?
Explain the function of data manager.
How can you split a table in to exactly half?
explain about index with examples
what is a trigger and types of triggers
Give a brief description of db2 isolation levels?
what is a corelated subquerry?
What is a Cartesian product?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
what is a collection?
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 ?
How is the value function used?