before altering a table is it necessary to lock ? if lock
what is it ? how to do ? ifi want to lock a table what is
that command ?
No Answer is Posted For this Question
Be the First to Post Answer
What r the comman abends in db2, jcl and cobol???????
What is DCLGEN ?
Return code 100 means?
What is bind package and plan in db2?
What are concurrency issues?
What information is held in SYSIBM.SYSCOPY?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Is ibm db2 open source?
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?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?