Explain what are the various isolation levels possible?
No Answer is Posted For this Question
Be the First to Post Answer
What is the role of data manager in the db2 database?
What is query_cache_limit?
How to find primary key of a table in db2?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
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 the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
When DB2 connection fails, will online program work or give errors.
What does db2 blu stand for?
Why do we need reorg in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
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 .
What is reorg in DB2