Re: Weird SQL Problem
Daniel Gross <[email protected]> Sun, 3 May 2026 12:31:07 +0200
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
SGkgQmlyZ2l0dGEsCgp0aGUgcHJvYmxlbSBzZWVtcyB0byBiZSBleGFjdGx5IHRoYXQKCglTUUwg Qk9PTEVBTiA8LT4gUlBHIElORAoJU1FMIENIQVIgPC0+IFJQRyBDSEFSCgpCdXQgSm9uIGlzIHVz aW5nIGEgU1FMIENIQVIgY29sdW1uIHdpdGggYSBSUEcgSU5EIHZhcmlhYmxlL3ZhbHVlIC0gYW5k IGJlY2F1c2UgSU5EID0gQk9PTEVBTgoKCUlORCAtPiBCT09MRUFOIC0+IENIQVIoMSkKCSpPTiAt PiAiVFJVRSIgLT4gIlQiCgpCdXQgdGhpcyBhbHNvIHdvcmtzIHRoZSBvdGhlciB3YXkgYXJvdW5k IC0gYSBDSEFSIHdpdGggdmFsdWUgIlQiIGlzIGNvcnJlY3RseSBjb252ZXJ0ZWQgdG8gKk9OIC0g YnV0IG9ubHkgZm9yIG5ld2x5IGNvbXBpbGVkIHByb2dyYW1zLgoKUmVnYXJkcywKRGFuaWVsCgoK PiBBbSAwMy4wNS4yMDI2IHVtIDEyOjI1IHNjaHJpZWIgQmlyZ2l0dGEgSGF1c2VyIDxIYXVzZXJA c3NzLXNvZnR3YXJlLmRlPjoKPiAKPiDvu79JdCBtdXN0IGJlIGEgYnVnIQo+IEFjY29yZGluZyB0 byB0aGUgZG9jdW1lbnRhdGlvbiB0aGUgZXF1aXZhbGVudCBmb3IgdGhlIEJPT0xFQU4gZGF0YSB0 eXBlIGluIFNRTCBpcyB0aGUgSU5EIGRhdGEgdHlwZSBpbiAoZW1iZWRkZWQpIFJQRy4KPiBJJ2Qg cmVwb3J0IGl0IHRvIElCTQo+IAo+IE1pdCBmcmV1bmRsaWNoZW4gR3LDvMOfZW4gLyBCZXN0IHJl Z2FyZHMKPiAKPiBCaXJnaXR0YSBIYXVzZXIKPiBNb2Rlcm5pemF0aW9uIOKAkyBFZHVjYXRpb24g 4oCTIENvbnN1bHRpbmcgb24gSUJNIGkKPiBEYXRhYmFzZSBhbmQgU29mdHdhcmUgQXJjaGl0ZWN0 ICAKPiBJQk0gQ2hhbXBpb24gc2luY2UgMjAyMAo+IAo+ICJTaG9vdCBmb3IgdGhlIG1vb24sIGV2 ZW4gaWYgeW91IG1pc3MsIHlvdSdsbCBsYW5kIGFtb25nIHRoZSBzdGFycy4iIChMZXMgQnJvd24p Cj4gIklmIHlvdSB0aGluayBlZHVjYXRpb24gaXMgZXhwZW5zaXZlLCB0cnkgaWdub3JhbmNlLiIg KERlcmVrIEJvaykKPiAiV2hhdCBpcyB3b3JzZSB0aGFuIHRyYWluaW5nIHlvdXIgc3RhZmYgYW5k IGxvc2luZyB0aGVtPyBOb3QgdHJhaW5pbmcgdGhlbSBhbmQga2VlcGluZyB0aGVtISIKPiAiVHJh aW4gcGVvcGxlIHdlbGwgZW5vdWdoIHNvIHRoZXkgY2FuIGxlYXZlLCB0cmVhdCB0aGVtIHdlbGwg ZW5vdWdoIHNvIHRoZXkgZG9uJ3Qgd2FudCB0by4gIiAoUmljaGFyZCBCcmFuc29uKQo+ICJMZWFy bmluZyBpcyBleHBlcmllbmNlIOKApiBldmVyeXRoaW5nIGVsc2UgaXMgb25seSBpbmZvcm1hdGlv biEiIChBbGJlcnQgRWluc3RlaW4pCj4gCj4gCj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0K PiBGcm9tOiBSUEc0MDAtTCA8cnBnNDAwLWwtYm91bmNlc0BsaXN0cy5taWRyYW5nZS5jb20+IE9u IEJlaGFsZiBPZiBKb24gUGFyaXMKPiBTZW50OiBTYXR1cmRheSwgMiBNYXkgMjAyNiAyMDoxNAo+ IFRvOiBSUEcgcHJvZ3JhbW1pbmcgb24gdGhlIElCTSBpIChBUy80MDAgYW5kIGlTZXJpZXMpIDxy cGc0MDAtbEBsaXN0cy5taWRyYW5nZS5jb20+Cj4gU3ViamVjdDogV2VpcmQgU1FMIFByb2JsZW0K PiAKPiBBcG9sb2dpZXMgaWYgdGhpcyBpcyBhIGR1cCBidXQgbXkgb3JpZ2luYWwgd2FzIHJlamVj dGVkIChJIHRoaW5rKSBhbmQgSSBjYW7igJl0IHNlZSBhbnl0aGluZyBmb3IgTWF5IGluIHRoZSBh cmNoaXZlcy4KPiAKPiBJIGhhdmUgYSB0YWJsZSBkZWZpbmVkIGFzOgo+IAo+IFJFR0lTVEVSVElN RSBUSU1FU1RBTVAgTk9UIE5VTEwgREVGQVVMVCBDVVJSRU5UX1RJTUVTVEFNUCwgV0VCSU5BUklE IERFQ0lNQUwoMTEsIDApIE5PVCBOVUxMIERFRkFVTFQgMCAsIFJFU1VMVCBDSEFSKDEpIE5PVCBO VUxMIERFRkFVTFQgJzAnICwgUkVHSVNURVJEQVRBIFZBUkNIQVIoMTAwMCkgQUxMT0NBVEUoMzAw KSBDQ1NJRCAzNyBOT1QgTlVMTAo+IAo+IFRoZSBTUUwgc3RhdGVtZW50IHRvIGluc2VydCB0aGUg ZGF0YSBpczoKPiAKPiBJbnNlcnQgaW50byB0YWJsZSAoIHdlYmluYXJJZCwgcmVzdWx0LCByZWdp c3RlckRhdGEgKQo+ICAgICAgICAgICAgIHZhbHVlcyggOndlYmluYXJJZCwgOnJlc3VsdCwgOnJl cXVlc3QgKTsKPiAKPiBXaGVyZSB0aGUgY29sdW1ucyBhcmUgYWxsIGRlZmluZWQgYXMgcGVyIHRo ZSB0YWJsZSBkZWZpbml0aW9uIC0gZXhjZXB0IHRoYXQg4oCccmVzdWx04oCdIGluIHRoZSBSUEcg Y29kZSBpcyBhbiBpbmRpY2F0b3IuCj4gCj4gVGhpcyBjb2RlIGhhcyBiZWVuIHJ1bm5pbmcgZm9y IGEgY291cGxlIG9mIHllYXJzIGJ1dCBzaW5jZSBvdXIgbW92ZSB0byA3LjYgaGFzIHN0YXJ0ZWQg dG8gc29tZXRpbWVzIHRocm93IFNRTENPREUgLTQwNCBhZ2FpbnN0IHRoZSDigJxyZXN1bHQiIGNv bHVtbiBjbGFpbWluZyB0aGF0IGl0cyBsZW5ndGggb2YgNCBleGNlZWRzIHRoZSBjYXBhY2l0eSBv ZiB0aGUgY29sdW1uLiBCdXQgaXQgaXNu4oCZdCA0IGxvbmcgaXQgaXMgMS4gUnVubmluZyBpbiBk ZWJ1ZywgSSBjYW4gc2VlIHRoYXQgdGhlIHRlbXAgdmFyaWFibGUgZm9yIOKAnHJlc3VsdOKAnSBj cmVhdGVkIGJ5IHRoZSBwcmUtcHJvY2Vzc29yIGlzIGNoYXIoMSkuCj4gCj4gTm90IHN1cmUgd2hl cmUgZWxzZSB0byBsb29rLgo+IAo+IEkgaGF2ZSBnb29nbGVkIGZvciBQVEZzIG9yIHJlcG9ydGVk IGVycm9ycyBidXQgYW0gbm90IHNlZWluZyBhbnl0aGluZy4KPiAKPiBBbnlvbmUgZ290IGFueSBp ZGVhcyBvbiB3aGVyZSB0byBsb29rIG5leHQ/Cj4gCj4gSSBoYXZlIGEgd29yayBhcm91bmQgLSBp ZiBJIGZhY2UgdGhlIGNhc3Qgb2YgdGhlIGluZGljYXRvciB0byBjaGFyKDEpIGl0IHdvcmtzLiAg R3Vlc3MgdGhlcmUgaXMgYSBidWcgaW4gdGhlIGNvZGUgZ2VuZXJhdGVkIGJ5IHRoZSBwcmUtY29t cGlsZXIuCj4gCj4gSW5zZXJ0IGludG8gcGFydG5lcjQwMC9zcWxyZWd0ZXN0ICggcmVzdWx0LCB3 ZWJpbmFySWQsICByZWdEYXRhICkKPiAgICAgICAgICAgICB2YWx1ZXMoICBjYXN0ICg6cmVzdWx0 IGFzIGNoYXIoMSkpLCA6d2ViaW5hcklkLCA6cmVxdWVzdCApOwo+IAo+IAo+IEpvbiBQYXJpcwo+ IAo+IC0tCj4gVGhpcyBpcyB0aGUgUlBHIHByb2dyYW1taW5nIG9uIElCTSBpIChSUEc0MDAtTCkg bWFpbGluZyBsaXN0IFRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRy YW5nZS5jb20gVG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9u cywKPiB2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9y cGc0MDAtbAo+IG9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQo+ IEJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hp dmVzIGF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCj4gCj4gUGxlYXNl IGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlv biByZWxhdGVkIHF1ZXN0aW9ucy4KPiAKPiAKPiAtLQo+IFRoaXMgaXMgdGhlIFJQRyBwcm9ncmFt bWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+IFRvIHBvc3QgYSBtZXNzYWdl IGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20KPiBUbyBzdWJzY3JpYmUsIHVuc3Vi c2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+IHZpc2l0OiBodHRwczovL2xpc3RzLm1p ZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sCj4gb3IgZW1haWw6IFJQRzQwMC1M LXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gQmVmb3JlIHBvc3RpbmcsIHBsZWFzZSB0YWtl IGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKPiBhdCBodHRwczovL2FyY2hpdmUubWlk cmFuZ2UuY29tL3JwZzQwMC1sLgo+IAo+IFBsZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5t aWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZCBxdWVzdGlvbnMuCj4gCi0t IApUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5n IGxpc3QKVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQRzQwMC1MQGxpc3RzLm1pZHJhbmdlLmNv bQpUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAp2aXNp dDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbApv ciBlbWFpbDogUlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KQmVmb3JlIHBvc3Rp bmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKYXQgaHR0cHM6 Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0MDAtbC4KClBsZWFzZSBjb250YWN0IHN1cHBvcnRA c3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZCBxdWVzdGlv bnMuCgo=