469,290 Members | 1,887 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,290 developers. It's quick & easy.

Edit routine & access path



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
1 1056

"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.

Similar topics

27 posts views Thread by Richard Blewett [DevelopMentor] | last post: by
4 posts views Thread by drakuu | last post: by
3 posts views Thread by Rik | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.