Explain correlated sub-queries.
No Answer is Posted For this Question
Be the First to Post Answer
What is a precompiler?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
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
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
How to access db2 tables in mainframe?
How can you classify the locks in db2?
What is catalog database in db2?
how can u nderstand the sql stmts executed successfully or not ?
How many clustering indexes can be defined for a table?
Which is faster delete or truncate?
What is schema in db2?
What is a cursor?