Answer Posted / s
When the application goes through precompile, compile and
link-edit phase and the bind plan is not done. Because when
you precompile a pgm, a new consistency token is placed in
modified source code and the DBRM but if you dont bind the
plan, the dbrm/package with that consistency token will not
be found. Hence the error message -818.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the use of predicate?
What is dclgen in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2 optimizer?
How do I delete a column in db2?
What is page size in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to fetch the last row from the table in SQL (db2)?
Is the primary key a clustered index?
Are views updateable?
What are the full forms of spufi and dclgen and why are they used?
How is a typical db2 batch pgm executed?
What is collection in db2 bind?