Answer Posted / hatam
A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not
| Is This Answer Correct ? | 0 Yes | 19 No |
Post New Answer View All Answers
List out the buffer pools in db2
How do I copy a table in db2?
What is the maximum length of sqlca?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the difference between cursor stability and repeatable read isolation levels?
What is host variable?
How to connect to db2 database from windows command line?
What do you mean by cursor?
What are the contents of dclgen?
What is check constraint. Explain with example.
How do you concatenate the firstname and lastname from emp table to give a complete name?
How to find schema of a table in db2?
What is drop table?
Which isolation level provides maximum concurrency?
How does coalesce work?
