Re: Weird SQL Problem
Peter Dow <[email protected]> Mon, 4 May 2026 10:55:58 -0700
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
U2luY2UgSSdtIHJldGlyZWQgYW5kIGhhdmUgdGltZSB0byBmb29sIGFyb3VuZCB3aXRoIHRoaXMs IEkgZ290IG9uIApQVUI0MDAgYW5kIHRyaWVkIHRoZSBmb2xsb3dpbmc6CgpDUkVBVEUgVEFCTEUg UENET1cxL1RFU1RCCiDCoChCwqAgQk9PTEVBTiBOT1QgTlVMTCBXSVRIIERFRkFVTFQKLCBDwqAg Q0hBUig1KSBOT1QgTlVMTCBXSVRIIERFRkFVTFQKLCBDMSBDSEFSKDEpIE5PVCBOVUxMIFdJVEgg REVGQVVMVAosIEMyIENIQVIoMikgTk9UIE5VTEwgV0lUSCBERUZBVUxUCiwgQzMgQ0hBUigzKSBO T1QgTlVMTCBXSVRIIERFRkFVTFQKLCBDNCBDSEFSKDQpIE5PVCBOVUxMIFdJVEggREVGQVVMVAos IEM1IENIQVIoNSkgTk9UIE5VTEwgV0lUSCBERUZBVUxUCiwgTsKgIElOVMKgIMKgIMKgTk9UIE5V TEwgV0lUSCBERUZBVUxUKQoKd2hpY2ggRFNQRkZEIFBDRE9XMS9URVNUQiBzaG93cyBhcwoKIMKg IMKgIMKgIMKgIMKgIMKgRGF0YcKgIMKgIMKgIMKgIEZpZWxkwqAgQnVmZmVywqAgwqAgQnVmZmVy wqAgwqAgwqAgwqAgRmllbGQgQ29sdW1uCkZpZWxkwqAgwqAgwqAgVHlwZcKgIMKgIMKgIMKgTGVu Z3RowqAgTGVuZ3RowqAgUG9zaXRpb27CoCDCoCDCoCDCoCBVc2FnZSBIZWFkaW5nCkLCoCDCoCDC oCDCoCDCoCBCT09MRUFOwqAgwqAgwqAgwqAgwqAxwqAgwqAgwqAgwqAxwqAgwqAgwqAgwqAgwqAx wqAgwqAgwqAgwqAgQm90aMKgIMKgIMKgQgpDwqAgwqAgwqAgwqAgwqAgQ0hBUsKgIMKgIMKgIMKg IMKgIMKgIDXCoCDCoCDCoCDCoDXCoCDCoCDCoCDCoCDCoDLCoCDCoCDCoCDCoCBCb3RowqAgwqAg wqBDCiDCoCBDb2RlZCBDaGFyYWN0ZXIgU2V0IElkZW50aWZpZXLCoCAuIC4gLiAuIC4gOsKgIMKg IDI3MwpDMcKgIMKgIMKgIMKgIMKgQ0hBUsKgIMKgIMKgIMKgIMKgIMKgIDHCoCDCoCDCoCDCoDHC oCDCoCDCoCDCoCDCoDfCoCDCoCDCoCDCoCBCb3RowqAgwqAgwqBDMQogwqAgQ29kZWQgQ2hhcmFj dGVyIFNldCBJZGVudGlmaWVywqAgLiAuIC4gLiAuIDrCoCDCoCAyNzMKQzLCoCDCoCDCoCDCoCDC oENIQVLCoCDCoCDCoCDCoCDCoCDCoCAywqAgwqAgwqAgwqAywqAgwqAgwqAgwqAgwqA4wqAgwqAg wqAgwqAgQm90aMKgIMKgIMKgQzIKIMKgIENvZGVkIENoYXJhY3RlciBTZXQgSWRlbnRpZmllcsKg IC4gLiAuIC4gLiA6wqAgwqAgMjczCkMzwqAgwqAgwqAgwqAgwqBDSEFSwqAgwqAgwqAgwqAgwqAg wqAgM8KgIMKgIMKgIMKgM8KgIMKgIMKgIMKgIDEwwqAgwqAgwqAgwqAgQm90aMKgIMKgIMKgQzMK IMKgIENvZGVkIENoYXJhY3RlciBTZXQgSWRlbnRpZmllcsKgIC4gLiAuIC4gLiA6wqAgwqAgMjcz CkM0wqAgwqAgwqAgwqAgwqBDSEFSwqAgwqAgwqAgwqAgwqAgwqAgNMKgIMKgIMKgIMKgNMKgIMKg IMKgIMKgIDEzwqAgwqAgwqAgwqAgQm90aMKgIMKgIMKgQzQKIMKgIENvZGVkIENoYXJhY3RlciBT ZXQgSWRlbnRpZmllcsKgIC4gLiAuIC4gLiA6wqAgwqAgMjczCkM1wqAgwqAgwqAgwqAgwqBDSEFS wqAgwqAgwqAgwqAgwqAgwqAgNcKgIMKgIMKgIMKgNcKgIMKgIMKgIMKgIDE3wqAgwqAgwqAgwqAg Qm90aMKgIMKgIMKgQzUKIMKgIENvZGVkIENoYXJhY3RlciBTZXQgSWRlbnRpZmllcsKgIC4gLiAu IC4gLiA6wqAgwqAgMjczCk7CoCDCoCDCoCDCoCDCoCBCSU5BUlnCoCDCoCDCoCDCoDnCoCAwwqAg wqAgwqAgwqA0wqAgwqAgwqAgwqAgMjLCoCDCoCDCoCDCoCBCb3RowqAgwqAgwqBOCgoKCklOU0VS VCBJTlRPIFBDRE9XMS9URVNUQiAoQiwgQykgVkFMVUVTCiDCoCAob24sICdvbicpCiwgKG9mZiwg J29mZicpCiwgKHRydWUsICd0cnVlJykKLCAoZmFsc2UsICdmYWxzZScpCiwgKCcwJywgJycnMCcn JykKLCAoJzEnLCAnJycxJycnKQosICgneWVzJywgJycneWVzJycnKQosICgnbm8nLCAnJydubycn JykKLCAoJ1QnLCAnJydUJycnKQosICgnRicsICcnJ0YnJycpCiwgKCd0JywgJycndCcnJykKLCAo J2YnLCAnJydmJycnKQoKClNFTEVDVCAqIEZST00gUENET1cxL1RFU1RCCgogwqAuLi4uKy4uLi4x Li4uLisuLi4uMi4uLi4rLi4uLjMuLi4uKy4uLi40Li4uLisuLi4uNQogwqBCwqAgQ8KgIMKgIMKg IEMxwqAgQzLCoCBDM8KgIMKgQzTCoCDCoCBDNcKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgTgog wqAxwqAgb27CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoDAKIMKgMMKgIG9mZsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIDAKIMKgMcKgIHRydWXCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDAKIMKg MMKgIGZhbHNlwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgMAogwqAwwqAgJzAnwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgMAogwqAxwqAgJzEnwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgMAogwqAxwqAg J3llcyfCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCAwCiDCoDDCoCAnbm8nwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAwCiDCoDHCoCAnVCfCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAwCiDCoDDCoCAnRifC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCAwCiDCoDHCoCAndCfCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAwCiDCoDDCoCAnZifCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAwCiDCoCoqKioqKioqwqAg RW5kIG9mIGRhdGHCoCAqKioqKioqKgoKVVBEQVRFIFBDRE9XMS9URVNUQgpTRVQgQzEgPSBCCiDC oCDCoCxDMiA9IEIKIMKgIMKgLEMzID0gQgogwqAgwqAsQzQgPSBCCiDCoCDCoCxDNSA9IEIKIMKg IMKgLE7CoCA9IEIKVmFsdWUgZm9yIGNvbHVtbiBvciB2YXJpYWJsZSBDMSB0b28gbG9uZy4KClVQ REFURSBQQ0RPVzEvVEVTVEIKU0VUIEMyID0gQgogwqAgwqAsQzMgPSBCCiDCoCDCoCxDNCA9IEIK IMKgIMKgLEM1ID0gQgogwqAgwqAsTsKgID0gQgpWYWx1ZSBmb3IgY29sdW1uIG9yIHZhcmlhYmxl IEMyIHRvbyBsb25nLgoKVVBEQVRFIFBDRE9XMS9URVNUQgpTRVQgQzMgPSBCCiDCoCDCoCxDNCA9 IEIKIMKgIMKgLEM1ID0gQgogwqAgwqAsTsKgID0gQgpWYWx1ZSBmb3IgY29sdW1uIG9yIHZhcmlh YmxlIEMzIHRvbyBsb25nLgoKVVBEQVRFIFBDRE9XMS9URVNUQgpTRVQgQzQgPSBCCiDCoCDCoCxD NSA9IEIKIMKgIMKgLE7CoCA9IEIKVmFsdWUgZm9yIGNvbHVtbiBvciB2YXJpYWJsZSBDNCB0b28g bG9uZy4KClVQREFURSBQQ0RPVzEvVEVTVEIKU0VUIEM1ID0gQgogwqAgwqAsTsKgID0gQgoxMiBy b3dzIHVwZGF0ZWQgaW4gVEVTVEIgaW4gUENET1cxLgoKU0VMRUNUICogRlJPTSBQQ0RPVzEvVEVT VEIKCi4uLi4rLi4uLjEuLi4uKy4uLi4yLi4uLisuLi4uMy4uLi4rLi4uLjQuLi4uKy4uLi41CkLC oCBDwqAgwqAgwqAgQzHCoCBDMsKgIEMzwqAgwqBDNMKgIMKgIEM1wqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqBOCjHCoCBvbsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIFRSVUXCoCBUUlVFwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAxCjDCoCBvZmbCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoEZBTFNFwqAgwqAgwqAgwqAgwqAgwqAgwqAgMAoxwqAgdHJ1ZcKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIFRSVUXCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDEKMMKgIGZhbHNl wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqBGQUxTRcKgIMKgIMKgIMKgIMKgIMKgIMKg IDAKMMKgICcwJ8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgRkFMU0XCoCDCoCDC oCDCoCDCoCDCoCDCoCAwCjHCoCAnMSfCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oFRSVUXCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDEKMcKgICd5ZXMnwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqBUUlVFwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAxCjDCoCAnbm8nwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgRkFMU0XCoCDCoCDCoCDCoCDCoCDCoCDCoCAwCjHC oCAnVCfCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoFRSVUXCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoDEKMMKgICdGJ8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgRkFM U0XCoCDCoCDCoCDCoCDCoCDCoCDCoCAwCjHCoCAndCfCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoFRSVUXCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDEKMMKgICdmJ8KgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgRkFMU0XCoCDCoCDCoCDCoCDCoCDCoCDCoCAwCioqKioq KioqwqAgRW5kIG9mIGRhdGHCoCAqKioqKioqKgoKCkkgZmluZCBpdCBpbnRlcmVzdGluZyB0aGF0 IHlvdSBjYW5ub3Qgc2V0IGEgQ0hBUig8NCkgZmllbGQgdG8gdGhlIHZhbHVlIApvZiBhIEJPT0xF QU4gZmllbGQuIEFuZCB5b3UgY2FuIHNldCBhIENIQVIoNCkgZmllbGQgdG8gdGhlIHZhbHVlIG9m IGEgCkJPT0xFQU4gZmllbGQgYXMgbG9uZyBhcyB0aGUgdmFsdWUgb2YgdGhlIEJPT0xFQU4gZmll bGQgaXMgVFJVRSwgYnV0IG5vdCAKaWYgaXQncyBGQUxTRS7CoCBUaGUgYWN0dWFsIHZhbHVlIG9m IHRoZSBCT09MRUFOIGZpZWxkIGlzIGVpdGhlciAnMCcgb3IgCicxJywgd2hpY2ggbWFrZXMgc2Vu c2UgdG8gYW4gUlBHIHByb2dyYW1tZXIsIGdpdmVuIHRoYXQgdGhlIHNpemUgb2YgdGhlIApmaWVs ZCBpcyAxIGJ5dGUuCgotLQoqUGV0ZXIgRG93KiAvCjkwOSA3OTMtOTA1MApwZXRlcmNkb3dAZ21h aWwuY29tCi8KLS0gClRoaXMgaXMgdGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAw LUwpIG1haWxpbmcgbGlzdApUbyBwb3N0IGEgbWVzc2FnZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMu bWlkcmFuZ2UuY29tClRvIHN1YnNjcmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9w dGlvbnMsCnZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZv L3JwZzQwMC1sCm9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQpC ZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZl cwphdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgoKUGxlYXNlIGNvbnRh Y3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxh dGVkIHF1ZXN0aW9ucy4KCg==