what are the bind parameters IBM DB2?
Submitted by: AdministratorBind parameters are:
MEMBER - In bind package,
LIRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
AQUIRE - Lock a tableon use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
in table
Submitted by: Administrator
MEMBER - In bind package,
LIRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
AQUIRE - Lock a tableon use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
in table
Submitted by: Administrator
Read Online IBM DB2 Job Interview Questions And Answers
Top IBM DB2 Questions
☺ | what are the bind parameters IBM DB2? |
☺ | What is sqlcode -811? |
☺ | What is sqlcode -922 ? |
☺ | Cursors can be declared in both working-storage & procedure |
☺ | Can you have more than one cursor open at any one time in a program ? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |