I use CS and update a page. Will the lock be released after
I am done with that page?
Answers were Sorted based on User's Feedback
Answer / m4io
No.
An update takes an exclusive lock. These persist until
commit.
Only shared locks will be released when you move away from
the page.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / s
Yes, the CS lock is held until the application locks the
next page.
Is This Answer Correct ? | 2 Yes | 4 No |
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is meant by AUTO COMMIT?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What are the levels of isolation available with DB2V4
What is image copy?
What is consistency token in db2?
What is dynamic SQL?
What is check constraint. Explain with example.
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is the maximum number of columns in a db2 table?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What os does db2 run on?