Answer / jessica

A plan is an executable module containing the access path
logic produced by the DB2 optimizer. It can be composed of
one or more DBRMs and packages. Before a DB2 for z/OS
program (with static SQL) can be run, it must have a plan
associated with it.

Plans are created by the BIND command. The plan is stored in
the DB2 directory and accessed when its program is run.
Information about the plan is stored in the DB2 catalog.

Answer / sadiq afroze

An application plan or package is generated by the bind to
define an access path

Answer / guest

It establish relation between application program and DB2
tables.

Answer / shankar

Only PLANS are executable and not PACKAGES. You have bind
your package to a PLAN while executing.

Answer / vira raguram.i

a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.

Answer / anil

A plan provides the channel between the aplication program
and the system which can be called up on call statements to
cobol for the sql code from db2 catalog when bind process
has done..

Answer / siri

BIND CAN HAPPEN TWO PROCESS...ONE IS PACKAGE...ANOTHER ONE IS PLAN....PLAN IS EXCUTABLE....WE BIND DBRM TO PACKAGE AND THEN INTO THE PLAN....WE BIND DIRECTLY DBRM TO PLAN...ONE DBRM IS CREATED FOR ONE PROGRAM....IN 10 DBRMS WE BIND INTO THE PLAN...IN 10 TIMES WE BIND INTO THE PLAN...IN CASE OF PACKAGE 10 DBRMS ARE BIND INTO THE PACKAGE AND THEN INTO THE PLAN ITS NO NEED TO BIND 10 TIMES..10 PACKAGES ARE INCLUDED IN ONE PACKAGE LIST..WE BIND ONE PACKAGE INTO THE PLAN AUTOMATICALLY 9 PACKAGES ARE BIND...PLAN IS EXCUTABLE...MEANS IT IS EXCUTABLE WITH LOAD MODULE...PLAN TIME STAMP TOKEN AND LOAD MODULE TIME STAMP TOKEN IF IT MATCH..THE PROGRAM IS EXCUTED...

Answer / ganesh

A db2 plan contains collections which in turn contains
packages.
A package contains the exectauble format of the sql
statements placed in the DBRM which was created during the
pre-comlie step.

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.

0 Answers  

How to take backup of table in db2?

0 Answers  

What are the different types of base tables?

0 Answers  

What is a cursor?

2 Answers  

What is a page in db2?

0 Answers  

wht displays the number of times a query modified ?

2 Answers   TCS,

How do I add a column in db2?

0 Answers  

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

What are foreign keys in db2?

0 Answers