Interested to Buy Any Domain ? << Click Here >> for more details...
what is plan?
is plan executable or package?
- 4 Answers
- 11629 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
paln is nothing but collection of packages
paln is executable where package is non-executable
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / tej
A small correction for Harsha's answer
Plan can also contain DBRMs along with collections of packages.
and Yes,Plan is executable where as package is not.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / nidhi
Plan and packages both are executable.
Package is the executable form of single DBRM while
multiple pacages or DBRM can be bind together through the
same plan.
| Is This Answer Correct ? | 2 Yes | 10 No |
Answer / 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 |
What is the meaning of -805 SQL return code?
How do I change the column size in db2?
What is the use of value function?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
what is the use of bind parameter, Replace?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is a cursor and what is its function?
What do you mean by NOT NULL? When will you use it?
What is a DB2 bind?
What is copy pending status in db2?
How can you count the number of rows from a table tab?
Can you access the DB2 Directory table using SQL?
COBOL 
