AW: Retrieving numeric partition ID in SQL
<[email protected]> Thu, 30 Jul 2026 08:47:23 +0200
| Newsgroups | gmane.comp.hardware.ibm.midrange |
|---|---|
| Message-ID | <[email protected]> |
SGVsbG8gRGFuLAoKbWF5YmUgdGhpcyBkb2VzIHRoZSB0cmljay4uLgoKU0VMRUNUIEhPU1RfTkFN RSwgUEFSVElUSU9OX0lELCBOVU1CRVJfT0ZfUEFSVElUSU9OUywgUEFSVElUSU9OX05BTUUgCkZS T00gUVNZUzIuU1lTVEVNX1NUQVRVU19JTkZPOwoKTWl0IGZyZXVuZGxpY2hlbiBHcsO8w59lbiAv IEtpbmQgcmVnYXJkcyAvIEJpZW4gw6Agdm91cywKIApTZcOhbiAgCiAKCiAKIAogCiAKCi0tLS0t VXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0KVm9uOiBNSURSQU5HRS1MIDxtaWRyYW5nZS1s LWJvdW5jZXNAbGlzdHMubWlkcmFuZ2UuY29tPiBJbSBBdWZ0cmFnIHZvbiBEaWVnbyBLZXNzZWxt YW4KR2VzZW5kZXQ6IDMwIEp1bHkgMjAyNiAwODozOApBbjogbWlkcmFuZ2UtbEBsaXN0cy5taWRy YW5nZS5jb20KQmV0cmVmZjogUmU6IFJldHJpZXZpbmcgbnVtZXJpYyBwYXJ0aXRpb24gSUQgaW4g U1FMCgpEYW4sCgppZiBTU0ggaXMgYWxzbyBhbiBhbHRlcm5hdGl2ZSwgeW91IGNhbiB1c2UgYSBz bWFsbCBzY3JpcHQgbGlrZSB0aGlzLCBmaXJzdCBzZW5kIHRoZSBzY3JpcHQsIHRoZW4gcnVuIGl0 IGFuZCByZXRyaWV2ZSB0aGUgZGF0YToKCnQ9JChzeXN0ZW0gIkNBTEwgUVNZUy9RTFpBUkNBUEki KQojIFBhcnRpdGlvbiBJRCMKc2VhcmNoc3RyaW5nPSJQQVJUSVRJT04gSUQ6IgpyZXN0PSR7dCMq JHNlYXJjaHN0cmluZ30KbHBhcmlkPSQoZWNobyAkcmVzdHxjdXQgLWQgIi4iIC1mMSApCmVjaG8g JGxwYXJpZAoKCi4uLiBvciB5b3UgY2FuIHJ1biBmcm9tIHlvdXIgcmVtb3RlIChMaW51eCBvciBN YWNPUykgc3lzdGVtIGEgc21hbGwgc2NyaXB0IGxpa2UgdGhpcyBvbmU6CgoKc3NoIHVzZXJAc2Vy dmVyICJzeXN0ZW0gLWkgJ0NBTEwgUVNZUy9RTFpBUkNBUEknICI+IC90bXAvcm10aWJtaS50eHQK dD0kKGNhdCAvdG1wL3JtdGlibWkudHh0KQojIFBhcnRpdGlvbiBJRCMKc2VhcmNoc3RyaW5nPSJQ QVJUSVRJT04gSUQ6IgpyZXN0PSR7dCMqJHNlYXJjaHN0cmluZ30KbHBhcmlkPSQoZWNobyAkcmVz dHxjdXQgLWQgIi4iIC1mMSApCmVjaG8gJGxwYXJpZAoKR29vZCBMdWNrIQoKLS0gClNhbHVkb3Mv UmVnYXJkcwoKLS0KCkRpZWdvIEUuIEtFU1NFTE1BTgoKCkVsIDI5LzA3LzI2IGEgbGFzIDExOjIy IHAubS4sIERhbiBCYWxlIHZpYSBNSURSQU5HRS1MIGVzY3JpYmnDszoKPiBJIG5lZWQgU1FMIHRv IHJldHJpZXZlIHRoZSBzZXJpYWwgbnVtYmVyLCBtb2RlbCwgcHJvY2Vzc29yIGZlYXR1cmUgY29k ZSwgYW5kIG51bWVyaWMgcGFydGl0aW9uIElELiAgVGhlIGZpcnN0IHRocmVlIGFyZSBzeXN0ZW0g dmFsdWVzLCBlYXN5IGVub3VnaC4gIFRoZSBudW1lcmljIHBhcnRpdGlvbiBJRCBoYXMgZXNjYXBl ZCByZXNvbHV0aW9uIHNvIGZhci4gIFNpbmNlIEkgYW0gZGV2ZWxvcGluZyBhIHByb2NlZHVyZSB0 aGF0IHVzZXMgMy1wYXJ0IG5hbWluZyB0byBydW4gdGhpcyBTUUwgb24gYWxsIG9mIG91ciBzeXN0 ZW1zIGZyb20gb25lIHN5c3RlbSwgSSBhbSB0cnlpbmcgdG8gYXZvaWQgaGF2aW5nIHRvIHV0aWxp emUgYW55dGhpbmcgdGhhdCBkb2Vzbid0IGFscmVhZHkgZXhpc3Qgb24gdGhlIHJlbW90ZSBzeXN0 ZW1zLiAgKFNvLCBJIHdhbnQgdG8gYXZvaWQgZGV2ZWxvcGluZyBhbiBhcHBsaWNhdGlvbiB0aGF0 IG5lZWRzIHRvIGJlIGRlcGxveWVkIHRvIGFsbCBvZiB0aGUgcmVtb3RlIHN5c3RlbXMuKQo+Cj4g SW4gQUNTIFJTUywgSSB0cmllZDoKPj4gQ0w6IGNhbGwgcXN5cy9RTFpBUkNBUEk7Cj4gYW5kIHRo aXMgcmV0dXJuZWQgdHdvIG1lc3NhZ2VzIHdpdGggdGhlIG91dHB1dCBpbiB0aGUgUlNTIG1lc3Nh Z2UgcGFuZSBhcyB3ZWxsIGFzIGluIHRoZSBqb2IgbG9nLiAgQXJlIHRoZXNlIG1lc3NhZ2VzIGlu dmlzaWJsZSB0byBTUUw/Cj4KPiBJIGFsc28gdHJpZWQ6Cj4+IHNlbGVjdCBxc3lzMi5xY21kZXhj KCdjYWxsIHFzeXMvUUxaQVJDQVBJJykgYXMgY2FsbHJlc3VsdCBmcm9tIFNZU0lCTS5zeXNkdW1t eTE7Cj4gYW5kIHRoaXMgcmV0dXJuZWQgYSByZXN1bHQgb2YgJzEnIChzdWNjZXNzKSBhbmQgdHdv IG1lc3NhZ2VzIHdpdGggdGhlIG91dHB1dCBpbiB0aGUgam9iIGxvZy4KPgo+IEkgbG9va2VkIGF0 IHRoZSBkbHBhcl9nZXRfaW5mbyBBUEkgYXQgaHR0cHM6Ly93d3cuaWJtLmNvbS9kb2NzL2VuL2kv Ny41LjA/dG9waWM9ZC1yZXRyaWV2ZS1wYXJ0aXRpb24taW5mb3JtYXRpb24tZGxwYXItZ2V0LWlu Zm8gYW5kIGh0dHBzOi8vd3d3LmlibS5jb20vc3VwcG9ydC9wYWdlcy9leGFtcGxlLXVzaW5nLWRs cGFyZ2V0aW5mby1hcGktZ2V0LW51bWVyaWNhbC1wYXJ0aXRpb24taWQtbG9naWNhbC1wYXJ0aXRp b24tbHBhciwgYnV0IG5vdCBzdXJlIGhvdyB0byBjYWxsIGl0IGluIFNRTCAoaWYgcG9zc2libGUp Lgo+Cj4gSWRlYXMgYXBwcmVjaWF0ZWQuCj4KPiAtIERhbiBCYWxlCj4gKioqIENPTkZJREVOVElB TElUWSBOT1RJQ0U6IFRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBjb21tdW5pY2F0 aW9uIG1heSBiZSBjb25maWRlbnRpYWwsIGFuZCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgdXNl IG9mIHRoZSByZWNpcGllbnRzIG5hbWVkIGFib3ZlLiBJZiB0aGUgcmVhZGVyIG9mIHRoaXMgbWVz c2FnZSBpcyBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCwgeW91IGFyZSBoZXJlYnkgbm90aWZp ZWQgdGhhdCBhbnkgZGlzc2VtaW5hdGlvbiwgZGlzdHJpYnV0aW9uLCBvciBjb3B5aW5nIG9mIHRo aXMgY29tbXVuaWNhdGlvbiwgb3IgYW55IG9mIGl0cyBjb250ZW50cywgaXMgc3RyaWN0bHkgcHJv aGliaXRlZC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBjb21tdW5pY2F0aW9uIGluIGVycm9y LCBwbGVhc2UgcmV0dXJuIGl0IHRvIHRoZSBzZW5kZXIgaW1tZWRpYXRlbHkgYW5kIGRlbGV0ZSB0 aGUgb3JpZ2luYWwgbWVzc2FnZSBhbmQgYW55IGNvcHkgb2YgaXQgZnJvbSB5b3VyIGNvbXB1dGVy IHN5c3RlbS4gSWYgeW91IGhhdmUgYW55IHF1ZXN0aW9ucyBjb25jZXJuaW5nIHRoaXMgbWVzc2Fn ZSwgcGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlci4gKioqCgotLSAKVGhpcyBpcyB0aGUgTWlkcmFu Z2UgU3lzdGVtcyBUZWNobmljYWwgRGlzY3Vzc2lvbiAoTUlEUkFOR0UtTCkgbWFpbGluZyBsaXN0 ClRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBNSURSQU5HRS1MQGxpc3RzLm1pZHJhbmdlLmNvbQpU byBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAp2aXNpdDog aHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9taWRyYW5nZS1sCm9y IGVtYWlsOiBNSURSQU5HRS1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCkJlZm9yZSBwb3N0 aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVzCmF0IGh0dHBz Oi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vbWlkcmFuZ2UtbC4KClBsZWFzZSBjb250YWN0IHN1cHBv cnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZCBxdWVz dGlvbnMuCgpZb3UgY2FuIGhlbHAgc3VwcG9ydCBtaWRyYW5nZS5jb20gYnkgdmlzaXRpbmcgaHR0 cHM6Ly9kb25hdGUubWlkcmFuZ2UuY29tIGFuZCBtYWtpbmcgYSBjb250cmlidXRpb24uCgotLSAK VGhpcyBpcyB0aGUgTWlkcmFuZ2UgU3lzdGVtcyBUZWNobmljYWwgRGlzY3Vzc2lvbiAoTUlEUkFO R0UtTCkgbWFpbGluZyBsaXN0ClRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBNSURSQU5HRS1MQGxp c3RzLm1pZHJhbmdlLmNvbQpUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlz dCBvcHRpb25zLAp2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0 aW5mby9taWRyYW5nZS1sCm9yIGVtYWlsOiBNSURSQU5HRS1MLXJlcXVlc3RAbGlzdHMubWlkcmFu Z2UuY29tCkJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhl IGFyY2hpdmVzCmF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vbWlkcmFuZ2UtbC4KClBs ZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3Jp cHRpb24gcmVsYXRlZCBxdWVzdGlvbnMuCgpZb3UgY2FuIGhlbHAgc3VwcG9ydCBtaWRyYW5nZS5j b20gYnkgdmlzaXRpbmcgaHR0cHM6Ly9kb25hdGUubWlkcmFuZ2UuY29tIGFuZCBtYWtpbmcgYSBj b250cmlidXRpb24uCg==