By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,130 Members | 2,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,130 IT Pros & Developers. It's quick & easy.

UDB 7.2 fp9, dynamic-sql plans with parameter-markers

P: n/a
Envirnoment is UDB 7.2 fp9 on AIX.

I'm familiar with using "dynexpln" for quickly comparing
access plans for directly executable queries.
dynexpln docs suggest it cannot work with sql that contains
parameter markers.
But, when there is no Control-centre (i.e. text only access
via korn-shell, no x-windows), how can I use db2 on aix command line programs
to get a plan for dynamic-sql that contains parameter-markers?

Any suggestions welcome, thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Mike wrote:
Envirnoment is UDB 7.2 fp9 on AIX.

I'm familiar with using "dynexpln" for quickly comparing
access plans for directly executable queries.
dynexpln docs suggest it cannot work with sql that contains
parameter markers.
But, when there is no Control-centre (i.e. text only access
via korn-shell, no x-windows), how can I use db2 on aix command line programs
to get a plan for dynamic-sql that contains parameter-markers?

Any suggestions welcome, thanks.


Did you consider consulting Product documentation - easily available on Web at:

http://publib.boulder.ibm.com/infoce...7luw/index.jsp
Search for "SQL Explain Facility"

Jan M. Nelken
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.