Interested to Buy Any Domain ? << Click Here >> for more details...
why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
- 9 Answers
- 36297 Views
- Infosys, TCS, Xansa, I also Faced
- E-Mail Answers
Answer Posted / srinivas g
Bind is type of compiler for the SQL statement.
It reads the SQL Statements from the DBRM and produces a mechanism to access data as directed by the SQL statements being bound.
Also checks Syntax, check for correctness of table & column definitions against the catalog information & performs authorization validation.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What kind of database is db2?
What is a db2 schema?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is dbrm? What it contains?
What is a system catalog table in db2?
Describe major components of db2?
What is plan in cobol db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the use of reorg in db2?
What is the connection string to connect to the DB2 Database ?
What is the physical storage length of the data types date, time, and timestamp?
Explain the contents that are a part of dclgen.
