Is db2 a database?
No Answer is Posted For this Question
Be the First to Post Answer
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
Why cursor is used in db2?
What is the SQL Communications Area and what are some of its key fields?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is reorg in database?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
When reorg is used?
What is COPY PENDING status?
What is the role of schema in the db2 database?