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

Edit routine & access path

P: n/a


Hello:

How does DB2 on s/390 resolve the access if the table its trying to
access has an edit routine? Will it ever use indexes before invoking
the edit routine when a select statement is executed? Under what all
conditions will it not use any of the indexes available to it

regards

Joey

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Joey Jackson" <jo*************@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...


Hello:

How does DB2 on s/390 resolve the access if the table its trying to
access has an edit routine? Will it ever use indexes before invoking
the edit routine when a select statement is executed? Under what all
conditions will it not use any of the indexes available to it

When you say "edit routines", do you mean FIELDPROCs, EDITPROCs, and
VALIDPROCs? If so, I'm surprised to see anyone still use those things. I'm
not sure they ever got much use and there is probably even less reason to
use them now that constraints, UDFs, etc. are present and relatively
powerful.

If I remember correctly, the fieldproc/editproc/validproc family all had to
be written in Assembler, making them fairly awkward to maintain, especially
if you didn't have a good Assembler programmer in your shop. That was the
main reason they didn't get a lot of use, at least among the people I knew
who were running DB2. As a result, you probably won't find many people who
know the effect of these procs on DB2 performance; you'll probably have to
set up a bunch of test cases and do your own explains to find out what they
do to index selection.

If that is NOT what you mean by "edit routines", what DO you mean?

Rhino
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.