What is db2 purescale?
What is index in db2?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is ALTER ?
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 should be specified along with a cursor in order to continue updating process after commit?
What is clone table?
Explain the function done by data manager?
What is null in db2?
What is load replace in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)