How to fetch the uncommited data from table ?
Answer / sudhir kumar
With the help of restart checkpoint logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What are db2 objects?
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 isolation level?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What is the difference between cursor stability and repeatable read isolation levels?
What is ALTER ?
What is the difference between TYPE 1 index & TYPE 2 index
What is the function of logging in the db2 database?
when does the SQL statement gets executed when you use cursor in the application programming ?
what is the role of the cursor in db2?