Re: Retrieving numeric partition ID in SQL
Diego Kesselman <[email protected]> Thu, 30 Jul 2026 00:37:45 -0600
| Newsgroups | gmane.comp.hardware.ibm.midrange |
|---|---|
| Message-ID | <[email protected]> |
RGFuLAoKaWYgU1NIIGlzIGFsc28gYW4gYWx0ZXJuYXRpdmUsIHlvdSBjYW4gdXNlIGEgc21hbGwg c2NyaXB0IGxpa2UgdGhpcywgCmZpcnN0IHNlbmQgdGhlIHNjcmlwdCwgdGhlbiBydW4gaXQgYW5k IHJldHJpZXZlIHRoZSBkYXRhOgoKdD0kKHN5c3RlbSAiQ0FMTCBRU1lTL1FMWkFSQ0FQSSIpCiMg UGFydGl0aW9uIElEIwpzZWFyY2hzdHJpbmc9IlBBUlRJVElPTiBJRDoiCnJlc3Q9JHt0Iyokc2Vh cmNoc3RyaW5nfQpscGFyaWQ9JChlY2hvICRyZXN0fGN1dCAtZCAiLiIgLWYxICkKZWNobyAkbHBh cmlkCgoKLi4uIG9yIHlvdSBjYW4gcnVuIGZyb20geW91ciByZW1vdGUgKExpbnV4IG9yIE1hY09T KSBzeXN0ZW0gYSBzbWFsbCAKc2NyaXB0IGxpa2UgdGhpcyBvbmU6CgoKc3NoIHVzZXJAc2VydmVy ICJzeXN0ZW0gLWkgJ0NBTEwgUVNZUy9RTFpBUkNBUEknICI+IC90bXAvcm10aWJtaS50eHQKdD0k KGNhdMKgL3RtcC9ybXRpYm1pLnR4dCkKIyBQYXJ0aXRpb24gSUQjCnNlYXJjaHN0cmluZz0iUEFS VElUSU9OIElEOiIKcmVzdD0ke3QjKiRzZWFyY2hzdHJpbmd9CmxwYXJpZD0kKGVjaG8gJHJlc3R8 Y3V0IC1kICIuIiAtZjEgKQplY2hvICRscGFyaWQKCkdvb2QgTHVjayEKCi0tIApTYWx1ZG9zL1Jl Z2FyZHMKCi0tCgpEaWVnbyBFLiBLRVNTRUxNQU4KCgpFbCAyOS8wNy8yNiBhIGxhcyAxMToyMiBw Lm0uLCBEYW4gQmFsZSB2aWEgTUlEUkFOR0UtTCBlc2NyaWJpw7M6Cj4gSSBuZWVkIFNRTCB0byBy ZXRyaWV2ZSB0aGUgc2VyaWFsIG51bWJlciwgbW9kZWwsIHByb2Nlc3NvciBmZWF0dXJlIGNvZGUs IGFuZCBudW1lcmljIHBhcnRpdGlvbiBJRC4gIFRoZSBmaXJzdCB0aHJlZSBhcmUgc3lzdGVtIHZh bHVlcywgZWFzeSBlbm91Z2guICBUaGUgbnVtZXJpYyBwYXJ0aXRpb24gSUQgaGFzIGVzY2FwZWQg cmVzb2x1dGlvbiBzbyBmYXIuICBTaW5jZSBJIGFtIGRldmVsb3BpbmcgYSBwcm9jZWR1cmUgdGhh dCB1c2VzIDMtcGFydCBuYW1pbmcgdG8gcnVuIHRoaXMgU1FMIG9uIGFsbCBvZiBvdXIgc3lzdGVt cyBmcm9tIG9uZSBzeXN0ZW0sIEkgYW0gdHJ5aW5nIHRvIGF2b2lkIGhhdmluZyB0byB1dGlsaXpl IGFueXRoaW5nIHRoYXQgZG9lc24ndCBhbHJlYWR5IGV4aXN0IG9uIHRoZSByZW1vdGUgc3lzdGVt cy4gIChTbywgSSB3YW50IHRvIGF2b2lkIGRldmVsb3BpbmcgYW4gYXBwbGljYXRpb24gdGhhdCBu ZWVkcyB0byBiZSBkZXBsb3llZCB0byBhbGwgb2YgdGhlIHJlbW90ZSBzeXN0ZW1zLikKPgo+IElu IEFDUyBSU1MsIEkgdHJpZWQ6Cj4+IENMOiBjYWxsIHFzeXMvUUxaQVJDQVBJOwo+IGFuZCB0aGlz IHJldHVybmVkIHR3byBtZXNzYWdlcyB3aXRoIHRoZSBvdXRwdXQgaW4gdGhlIFJTUyBtZXNzYWdl IHBhbmUgYXMgd2VsbCBhcyBpbiB0aGUgam9iIGxvZy4gIEFyZSB0aGVzZSBtZXNzYWdlcyBpbnZp c2libGUgdG8gU1FMPwo+Cj4gSSBhbHNvIHRyaWVkOgo+PiBzZWxlY3QgcXN5czIucWNtZGV4Yygn Y2FsbCBxc3lzL1FMWkFSQ0FQSScpIGFzIGNhbGxyZXN1bHQgZnJvbSBTWVNJQk0uc3lzZHVtbXkx Owo+IGFuZCB0aGlzIHJldHVybmVkIGEgcmVzdWx0IG9mICcxJyAoc3VjY2VzcykgYW5kIHR3byBt ZXNzYWdlcyB3aXRoIHRoZSBvdXRwdXQgaW4gdGhlIGpvYiBsb2cuCj4KPiBJIGxvb2tlZCBhdCB0 aGUgZGxwYXJfZ2V0X2luZm8gQVBJIGF0IGh0dHBzOi8vd3d3LmlibS5jb20vZG9jcy9lbi9pLzcu NS4wP3RvcGljPWQtcmV0cmlldmUtcGFydGl0aW9uLWluZm9ybWF0aW9uLWRscGFyLWdldC1pbmZv IGFuZCBodHRwczovL3d3dy5pYm0uY29tL3N1cHBvcnQvcGFnZXMvZXhhbXBsZS11c2luZy1kbHBh cmdldGluZm8tYXBpLWdldC1udW1lcmljYWwtcGFydGl0aW9uLWlkLWxvZ2ljYWwtcGFydGl0aW9u LWxwYXIsIGJ1dCBub3Qgc3VyZSBob3cgdG8gY2FsbCBpdCBpbiBTUUwgKGlmIHBvc3NpYmxlKS4K Pgo+IElkZWFzIGFwcHJlY2lhdGVkLgo+Cj4gLSBEYW4gQmFsZQo+ICoqKiBDT05GSURFTlRJQUxJ VFkgTk9USUNFOiBUaGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgY29tbXVuaWNhdGlv biBtYXkgYmUgY29uZmlkZW50aWFsLCBhbmQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHVzZSBv ZiB0aGUgcmVjaXBpZW50cyBuYW1lZCBhYm92ZS4gSWYgdGhlIHJlYWRlciBvZiB0aGlzIG1lc3Nh Z2UgaXMgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHlvdSBhcmUgaGVyZWJ5IG5vdGlmaWVk IHRoYXQgYW55IGRpc3NlbWluYXRpb24sIGRpc3RyaWJ1dGlvbiwgb3IgY29weWluZyBvZiB0aGlz IGNvbW11bmljYXRpb24sIG9yIGFueSBvZiBpdHMgY29udGVudHMsIGlzIHN0cmljdGx5IHByb2hp Yml0ZWQuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwg cGxlYXNlIHJldHVybiBpdCB0byB0aGUgc2VuZGVyIGltbWVkaWF0ZWx5IGFuZCBkZWxldGUgdGhl IG9yaWdpbmFsIG1lc3NhZ2UgYW5kIGFueSBjb3B5IG9mIGl0IGZyb20geW91ciBjb21wdXRlciBz eXN0ZW0uIElmIHlvdSBoYXZlIGFueSBxdWVzdGlvbnMgY29uY2VybmluZyB0aGlzIG1lc3NhZ2Us IHBsZWFzZSBjb250YWN0IHRoZSBzZW5kZXIuICoqKgoKLS0gClRoaXMgaXMgdGhlIE1pZHJhbmdl IFN5c3RlbXMgVGVjaG5pY2FsIERpc2N1c3Npb24gKE1JRFJBTkdFLUwpIG1haWxpbmcgbGlzdApU byBwb3N0IGEgbWVzc2FnZSBlbWFpbDogTUlEUkFOR0UtTEBsaXN0cy5taWRyYW5nZS5jb20KVG8g c3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKdmlzaXQ6IGh0 dHBzOi8vbGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vbWlkcmFuZ2UtbApvciBl bWFpbDogTUlEUkFOR0UtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQpCZWZvcmUgcG9zdGlu ZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwphdCBodHRwczov L2FyY2hpdmUubWlkcmFuZ2UuY29tL21pZHJhbmdlLWwuCgpQbGVhc2UgY29udGFjdCBzdXBwb3J0 QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rp b25zLgoKWW91IGNhbiBoZWxwIHN1cHBvcnQgbWlkcmFuZ2UuY29tIGJ5IHZpc2l0aW5nIGh0dHBz Oi8vZG9uYXRlLm1pZHJhbmdlLmNvbSBhbmQgbWFraW5nIGEgY29udHJpYnV0aW9uLgo=