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 can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is load utility in db2?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What is the maximum number of columns in a db2 table?
When is the access path determined for dynamic SQL?
How is the value function used?
What is a root page?
wht r the requirements for writing a cobol-db2 pgm ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
How can we define a table? How can we apply SEARCH ALL on it ?