How to compare data between two tables in db2?
No Answer is Posted For this Question
Be the First to Post Answer
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is meant by explain?
What is bind plan?
When do you specify the isolation level?
What is reorg?
How do you do the EXPLAIN of a dynamic SQL statement?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
how to execute qcmdexc in rpgle?plz write code also?
select 100 records from million records ?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is a synonym ?
What is bufferpool in db2?