| IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...
Help & Support Forums for IBM Mainframe computers Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7, CA-11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, VSAM, ISPF, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
mailsaurabh.tripathi
Joined: 22 May 2008
Posts: 14
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: 253
Location: Pune
|
| 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: 313
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 |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|