IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Is it possible to select from a partition range

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
mailsaurabh.tripathi



Joined: 22 May 2008
Posts: 22
Location: hyderabad
Posted: Mon Jul 07, 2008 4:33 pm    Post subject: Is it possible to select from a partition range  
Is it possible to select from a partition range?

ie.

something like

select * from table partition range (partition1,partition3);
Back to top  
ksk



Joined: 08 Jun 2006
Posts: 307
Location: Pune, India
Posted: Mon Jul 07, 2008 5:40 pm    Post subject:  
No, you can retreive the partition range using IBM table SYSIBM.SYSTABLEPART
Back to top  
ashimer



Joined: 13 Feb 2004
Posts: 360
Location: Bangalore
Posted: Mon Jul 07, 2008 8:29 pm    Post subject:  
saurabh,

If you can use your query predicates judiciously to eliminate the unwanted partitions then you can get the data from the required partitions ...
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM