Is it possible to select from a partition range

mailsaurabh.tripathi · New User Joined: 22 May 2008 Posts: 56 Location: hyderabad

Is it possible to select from a partition range?

ie.

something like

select * from table partition range (partition1,partition3);

ksk · Posted: Mon Jul 07, 2008 5:40 pm

No, you can retreive the partition range using IBM table SYSIBM.SYSTABLEPART

ashimer · Posted: Mon Jul 07, 2008 8:29 pm

saurabh,

If you can use your query predicates judiciously to eliminate the unwanted partitions then you can get the data from the required partitions ...