What is the error code -803 ?
Answers were Sorted based on User's Feedback
Answer / anurag singh
Inserted or updated value is not valid ( Duplicate )
| Is This Answer Correct ? | 6 Yes | 2 No |
What are the four lockable units for DB2?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is a view? Why use it?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
Define predicate?
What is consistency token in db2?
What is the FREE command?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Which is faster delete or truncate?
what is the input to PLAN? what is the input to DBRM?
What is the purpose of using commit?