why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
- 9 Answers
- 34231 Views
- Infosys, TCS, Xansa, I also Faced
- E-Mail Answers
Answer Posted / harish
ACTUALLY BIND PLAN CONSISTS OF DBRM SO IN DB2 WE NEED TO
CREATE UNIQUE PLAN NAME TO GET EXECTABLE LOAD MODULE AND
DURING RUN PROG WE NEED TO GIVE PLANNAME AND MODIFIED
SOURCE LIB .
IF WE DIDNOT BIND WE WILL GET -805 ERROR I,E PROG NAME OR
DBRM NOT FOUND IN PLAN
SUPPOSE IF YOU MADE ANY CHANGES IN ANY PROGRAM THEN COMPILE
AND BIND PACKAGE ,BIND PLAN .SUPPOSE IF U DONE EVERYTING
AND FORGOT TO BIND IN THAT CASE YOU WILL GET -818 ERROR I,E
TIMESTAMP ERROR...
pls let me know if u have any queries
HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How will you return the number of records in table?
How to find the number of rows in db2 tables?
How do I add a column to a table in db2?
What os does db2 run on?
what is a corelated subquerry?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How can record locking be achieved in those DB2 versions which do not support it?
How to find the number of rows in a db2 table?
What is collection in db2 bind?
What is sqlca?
What is the use of runstats in db2?
Are views updateable?
Define predicate?
Is it possible using max on a char column?
