Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
1 12482i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
EDS,
5 9304how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
IBM,
10 15033Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
3154Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
1 8850Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
IBM,
2 7031Plan has the optimized access path in it. But is that optimized access path is attained or known
IBM,
1 4532
How will you return the number of records in table?
What is access path in db2?
How do you stop a db2 database in linux?
How do you find the maximum value in a column in db2?
What is a db2 cursor?
What is blu acceleration in db2?
Why do we need reorg in db2?
What is db2 plan table?
What are the two types of logging in the db2 database? Explain them.
What is cursor in dbms?
What is dbrm? When it will be created?
What are foreign keys in db2?
Which component is responsible for processing sql statements and selecting access paths?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is package in db2 mainframe?