470,636 Members | 1,447 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Which predicates are stage 1 and indexable?

Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and
indexable in DB2 UDB for z/OS Version 8.

Is there any way to find out which predicates are stage 1 and indexable
in V7/V8?

Had a look in the SQL references but no luck.

TIA, Markus

Jan 3 '06 #1
2 3597
Markus Neifer wrote:
Hi, i've read that 'Col BETWEEN expr1 and expr2' became stage 1 and
indexable in DB2 UDB for z/OS Version 8.

Is there any way to find out which predicates are stage 1 and indexable
in V7/V8?

Had a look in the SQL references but no luck.

TIA, Markus


The information you need is located in the Administration Guide, which
you can download for free from the IBM web site.
http://www-306.ibm.com/software/data...s/v7books.html
http://www-306.ibm.com/software/data...s/v8books.html

Do a search on "predicate types and processing" in the PDF version of
the manual.

Jan 3 '06 #2
> The information you need is located in the Administration Guide

Thanks a lot! You saved me.

I come from DB2 UDB for LUW and it seems that things are quite
different with DB2 UDB for z/OS...

Greetings, Markus

Jan 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by dayzman | last post: by
1 post views Thread by Trent Buck | last post: by
4 posts views Thread by Arun Srinivasan | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.