Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sabahat khan
The ACQUIRE and RELEASE options of bind determine when DB2
locks an object (table, partition, or table space)which
your application uses and when it releases the lock.
The options apply to static SQL statements(like Embedded
SQL statement in application program), which are bound
before your program executes. If your program executes
dynamic SQL statements, the objects they lock are locked
when first accessed and released at the next commit point
though some locks acquired for dynamic SQL might be held
past commit points.
ACQUIRE(ALLOCATE)
Acquires the lock when the object is allocated. This option
is not allowed for BIND or REBIND PACKAGE.
ACQUIRE(USE)
Acquires the lock when the object is first accessed.
RELEASE(DEALLOCATE)
Releases the lock when the object is deallocated (the
application ends). The value has no effect on dynamic SQL
statements, which always use RELEASE(COMMIT)
RELEASE(COMMIT)
Releases the lock at the next commit point, unless cursors.
If the application accesses the object again, it must
acquire the lock again.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Define declaration generator (dclgen).
What is iseries database?
What is ibm db2 connect?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is bind package and plan in db2?
What is the connection string to connect to the DB2 Database ?
How do we specify index to include or not during bind process.
What is the difference between bind and rebind in db2?
What are the prerogatives?
How to connect to db2 database from windows command line?
Is db2 a programming language?
What does db2 mean?
What is bind in db2?
What is isolation level in db2?
