Weird SQL Problem
Jon Paris <[email protected]> Sat, 2 May 2026 14:14:28 -0400
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
QXBvbG9naWVzIGlmIHRoaXMgaXMgYSBkdXAgYnV0IG15IG9yaWdpbmFsIHdhcyByZWplY3RlZCAo SSB0aGluaykgYW5kIEkgY2Fu4oCZdCBzZWUgYW55dGhpbmcgZm9yIE1heSBpbiB0aGUgYXJjaGl2 ZXMuCgpJIGhhdmUgYSB0YWJsZSBkZWZpbmVkIGFzOgoKUkVHSVNURVJUSU1FIFRJTUVTVEFNUCBO T1QgTlVMTCBERUZBVUxUIENVUlJFTlRfVElNRVNUQU1QLCAKV0VCSU5BUklEIERFQ0lNQUwoMTEs IDApIE5PVCBOVUxMIERFRkFVTFQgMCAsIApSRVNVTFQgQ0hBUigxKSBOT1QgTlVMTCBERUZBVUxU ICcwJyAsIApSRUdJU1RFUkRBVEEgVkFSQ0hBUigxMDAwKSBBTExPQ0FURSgzMDApIENDU0lEIDM3 IE5PVCBOVUxMIAoKVGhlIFNRTCBzdGF0ZW1lbnQgdG8gaW5zZXJ0IHRoZSBkYXRhIGlzOgoKSW5z ZXJ0IGludG8gdGFibGUgKCB3ZWJpbmFySWQsIHJlc3VsdCwgcmVnaXN0ZXJEYXRhICkKICAgICAg ICAgICAgIHZhbHVlcyggOndlYmluYXJJZCwgOnJlc3VsdCwgOnJlcXVlc3QgKTsKCldoZXJlIHRo ZSBjb2x1bW5zIGFyZSBhbGwgZGVmaW5lZCBhcyBwZXIgdGhlIHRhYmxlIGRlZmluaXRpb24gLSBl eGNlcHQgdGhhdCDigJxyZXN1bHTigJ0gaW4gdGhlIFJQRyBjb2RlIGlzIGFuIGluZGljYXRvci4g CgpUaGlzIGNvZGUgaGFzIGJlZW4gcnVubmluZyBmb3IgYSBjb3VwbGUgb2YgeWVhcnMgYnV0IHNp bmNlIG91ciBtb3ZlIHRvIDcuNiBoYXMgc3RhcnRlZCB0byBzb21ldGltZXMgdGhyb3cgU1FMQ09E RSAtNDA0IGFnYWluc3QgdGhlIOKAnHJlc3VsdCIgY29sdW1uIGNsYWltaW5nIHRoYXQgaXRzIGxl bmd0aCBvZiA0IGV4Y2VlZHMgdGhlIGNhcGFjaXR5IG9mIHRoZSBjb2x1bW4uIEJ1dCBpdCBpc27i gJl0IDQgbG9uZyBpdCBpcyAxLiBSdW5uaW5nIGluIGRlYnVnLCBJIGNhbiBzZWUgdGhhdCB0aGUg dGVtcCB2YXJpYWJsZSBmb3Ig4oCccmVzdWx04oCdIGNyZWF0ZWQgYnkgdGhlIHByZS1wcm9jZXNz b3IgaXMgY2hhcigxKS4gCgpOb3Qgc3VyZSB3aGVyZSBlbHNlIHRvIGxvb2suCgpJIGhhdmUgZ29v Z2xlZCBmb3IgUFRGcyBvciByZXBvcnRlZCBlcnJvcnMgYnV0IGFtIG5vdCBzZWVpbmcgYW55dGhp bmcuCgpBbnlvbmUgZ290IGFueSBpZGVhcyBvbiB3aGVyZSB0byBsb29rIG5leHQ/CgpJIGhhdmUg YSB3b3JrIGFyb3VuZCAtIGlmIEkgZmFjZSB0aGUgY2FzdCBvZiB0aGUgaW5kaWNhdG9yIHRvIGNo YXIoMSkgaXQgd29ya3MuICBHdWVzcyB0aGVyZSBpcyBhIGJ1ZyBpbiB0aGUgY29kZSBnZW5lcmF0 ZWQgYnkgdGhlIHByZS1jb21waWxlci4KCkluc2VydCBpbnRvIHBhcnRuZXI0MDAvc3FscmVndGVz dCAoIHJlc3VsdCwgd2ViaW5hcklkLCAgcmVnRGF0YSApCiAgICAgICAgICAgICB2YWx1ZXMoICBj YXN0ICg6cmVzdWx0IGFzIGNoYXIoMSkpLCA6d2ViaW5hcklkLCA6cmVxdWVzdCApOwoKCkpvbiBQ YXJpcwoKLS0gClRoaXMgaXMgdGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwp IG1haWxpbmcgbGlzdApUbyBwb3N0IGEgbWVzc2FnZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlk cmFuZ2UuY29tClRvIHN1YnNjcmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlv bnMsCnZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Jw ZzQwMC1sCm9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQpCZWZv cmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwph dCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgoKUGxlYXNlIGNvbnRhY3Qg c3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVk IHF1ZXN0aW9ucy4KCg==