What is a DB2 bind?
Answer / tintu raveendran
It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.
| Is This Answer Correct ? | 8 Yes | 2 No |
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
how to copy the host variables from ps file into cobol program other than include statement
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
Explain the use of the WHERE clause.
What are the three lock types?
How can you get the number of rows impacted by the last executed query?
what are bind concepts in db2 cobol?
How can you quickly find out the # of rows updated after an update statement?
What is nvl in db2?
What is a SELECT statement?
What does db2 mean?
How do you simulate the explain of an embedded sql statement in spufi/qmf?