View previous topic :: View next topic
|
Author |
Message |
bijjaragi Warnings : 2 New User
Joined: 08 Sep 2006 Posts: 7 Location: Bangalore
|
|
|
|
hi friends
can you tell me the difference between bind and plan
Regards
Vivek |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Package and plan?
Bind is an action. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
Bind is a process (activated as a command to DB2). Plan is one of DB2's run time components.
O. |
|
Back to top |
|
|
jayant_tibhe
New User
Joined: 25 Feb 2006 Posts: 27 Location: Pune
|
|
|
|
BIND
The bind operation generates operational form of SQL or internal control structures to access the data. All control structures in a package are derived from the SQL statements embedded in a single source program.
PLAN
An application plan relates an application process to a local instance of DB2,
specifies processing options, and contains one or both of the following elements: A list of package names. The bound form of SQL statements taken from one or more DBRMs. Every DB2 application requires an application plan. Plans and packages are created using the DB2 subcommands BIND PLAN and BIND PACKAGE |
|
Back to top |
|
|
|