Re: Weird SQL Problem
Jon Paris <[email protected]> Sat, 2 May 2026 14:43:25 -0400
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
SSB1bmRlcnN0YW5kIGFsbCB0aGF0IERhbmllbCBidXQgdGhlIHVuZGVybHlpbmcgZGF0YSB0eXBl IGZvciBhbiBSUEcgaW5kaWNhdG9yIGhhcyBhbHdheXMgYmVlbiBjaGFyKDEpLgoKUGVyaGFwcyBt b3JlIHRvIHRoZSBwb2ludDogCgoxKSBpZiB0aGlzIHdhcyBhIGNvZGluZyBlcnJvciBvbiBteSBw YXJ0LCB0aGUgcHJlLWNvbXBpbGVyIHNob3VsZCBzcGl0IGl0IG91dC4gTm90IGFjY2VwdCBpdCBh bmQgc2NyZXcgdXAgYXQgcnVuIHRpbWUuCgoyKSBUaGlzIGhhcyBiZWVuIHdvcmtpbmcgc2luY2Ug MjAyNAoKMykgSWYgSSBtYW51YWxseSBjYXN0IHRoZSBpbmRpY2F0b3IgSSBubyBsb25nZXIgZ2V0 IGFuIGVycm9yIGJ1dCB0aGUgdmFsdWUgcmV0dXJuZWQgaXMgbm90IHplcm8gb3IgMS4gSXQgaXMg Y3VycmVudGx5IGEg4oCcVOKAnSBmb3IgdGhlICpPbiBjb25kaXRpb24uCgo0KSBUaGUgdGFibGUg aGFzIGJlZW4gYXJvdW5kIGZvciBzb21lIHRpbWUgYW5kIGEgYnVuY2ggb2Ygb3RoZXIgc3R1ZmYg d291bGQgaGF2ZSB0byBjaGFuZ2UgaWYgSSBzd2l0Y2ggaXQgdG8gYm9vbGVhbi4gSeKAmWQgcmF0 aGVyIGF2b2lkIHRoYXQuCgpMb29rcyBsaWtlIEnigJltIGdvaW5nIHRvIGhhdmUgdG8g4oCcbWFu dWFsbHnigJ0gaW50ZXJwcmV0IHRoZSBpbmRpY2F0b3IgYW5kIHBhc3MgdGhlIHJlc3VsdGluZyBj aGFyIGZpZWxkIHRvIHRoZSBTUUwuCgoKSm9uIFBhcmlzIAoKCj4gT24gTWF5IDIsIDIwMjYsIGF0 IDE0OjI3LCBEYW5pZWwgR3Jvc3MgPGRhbmllbEBxcGdtci5kZT4gd3JvdGU6Cj4gCj4gSGkgSm9u LAo+IAo+IGlmIHlvdSB1c2UgYW4gaW5kaWNhdG9yIGZvciB0aGUgUkVTVUxUIGNvbHVtbiwgdGhl IG5hdHVyYWwgU1FMIGRhdGEgdHlwZSB3b3VsZCBiZSBCT09MRUFOLiBBbiBpbmRpY2F0b3IgY2Fu IG9ubHkgYmUgKk9OIG9yICpPRkYgLSBhIEJvb2xlYW4gY29sdW1uIGNhbiBvbmx5IGJlIFRSVUUg KCpPTikgb3IgRkFMU0UgKCpPRkYpIC0gYW4gZW1iZWRkZWQgU1FMIGlzIGNvcnJlY3RseSBjYXN0 aW5nL2NvbnZlcnRpbmcgYmV0d2VlbiB0aG9zZSAyIGRhdGEgdHlwZXMuIAo+IAo+IEhUSAo+IERh bmllbAo+IAo+IAo+PiBBbSAwMi4wNS4yMDI2IHVtIDIwOjE1IHNjaHJpZWIgSm9uIFBhcmlzIDxq b24ucGFyaXNAcGFydG5lcjQwMC5jb20+Ogo+PiAKPj4g77u/QXBvbG9naWVzIGlmIHRoaXMgaXMg YSBkdXAgYnV0IG15IG9yaWdpbmFsIHdhcyByZWplY3RlZCAoSSB0aGluaykgYW5kIEkgY2Fu4oCZ dCBzZWUgYW55dGhpbmcgZm9yIE1heSBpbiB0aGUgYXJjaGl2ZXMuCj4+IAo+PiBJIGhhdmUgYSB0 YWJsZSBkZWZpbmVkIGFzOgo+PiAKPj4gUkVHSVNURVJUSU1FIFRJTUVTVEFNUCBOT1QgTlVMTCBE RUZBVUxUIENVUlJFTlRfVElNRVNUQU1QLAo+PiBXRUJJTkFSSUQgREVDSU1BTCgxMSwgMCkgTk9U IE5VTEwgREVGQVVMVCAwICwKPj4gUkVTVUxUIENIQVIoMSkgTk9UIE5VTEwgREVGQVVMVCAnMCcg LAo+PiBSRUdJU1RFUkRBVEEgVkFSQ0hBUigxMDAwKSBBTExPQ0FURSgzMDApIENDU0lEIDM3IE5P VCBOVUxMCj4+IAo+PiBUaGUgU1FMIHN0YXRlbWVudCB0byBpbnNlcnQgdGhlIGRhdGEgaXM6Cj4+ IAo+PiBJbnNlcnQgaW50byB0YWJsZSAoIHdlYmluYXJJZCwgcmVzdWx0LCByZWdpc3RlckRhdGEg KQo+PiAgICAgICAgICAgIHZhbHVlcyggOndlYmluYXJJZCwgOnJlc3VsdCwgOnJlcXVlc3QgKTsK Pj4gCj4+IFdoZXJlIHRoZSBjb2x1bW5zIGFyZSBhbGwgZGVmaW5lZCBhcyBwZXIgdGhlIHRhYmxl IGRlZmluaXRpb24gLSBleGNlcHQgdGhhdCDigJxyZXN1bHTigJ0gaW4gdGhlIFJQRyBjb2RlIGlz IGFuIGluZGljYXRvci4KPj4gCj4+IFRoaXMgY29kZSBoYXMgYmVlbiBydW5uaW5nIGZvciBhIGNv dXBsZSBvZiB5ZWFycyBidXQgc2luY2Ugb3VyIG1vdmUgdG8gNy42IGhhcyBzdGFydGVkIHRvIHNv bWV0aW1lcyB0aHJvdyBTUUxDT0RFIC00MDQgYWdhaW5zdCB0aGUg4oCccmVzdWx0IiBjb2x1bW4g Y2xhaW1pbmcgdGhhdCBpdHMgbGVuZ3RoIG9mIDQgZXhjZWVkcyB0aGUgY2FwYWNpdHkgb2YgdGhl IGNvbHVtbi4gQnV0IGl0IGlzbuKAmXQgNCBsb25nIGl0IGlzIDEuIFJ1bm5pbmcgaW4gZGVidWcs IEkgY2FuIHNlZSB0aGF0IHRoZSB0ZW1wIHZhcmlhYmxlIGZvciDigJxyZXN1bHTigJ0gY3JlYXRl ZCBieSB0aGUgcHJlLXByb2Nlc3NvciBpcyBjaGFyKDEpLgo+PiAKPj4gTm90IHN1cmUgd2hlcmUg ZWxzZSB0byBsb29rLgo+PiAKPj4gSSBoYXZlIGdvb2dsZWQgZm9yIFBURnMgb3IgcmVwb3J0ZWQg ZXJyb3JzIGJ1dCBhbSBub3Qgc2VlaW5nIGFueXRoaW5nLgo+PiAKPj4gQW55b25lIGdvdCBhbnkg aWRlYXMgb24gd2hlcmUgdG8gbG9vayBuZXh0Pwo+PiAKPj4gSSBoYXZlIGEgd29yayBhcm91bmQg LSBpZiBJIGZhY2UgdGhlIGNhc3Qgb2YgdGhlIGluZGljYXRvciB0byBjaGFyKDEpIGl0IHdvcmtz LiAgR3Vlc3MgdGhlcmUgaXMgYSBidWcgaW4gdGhlIGNvZGUgZ2VuZXJhdGVkIGJ5IHRoZSBwcmUt Y29tcGlsZXIuCj4+IAo+PiBJbnNlcnQgaW50byBwYXJ0bmVyNDAwL3NxbHJlZ3Rlc3QgKCByZXN1 bHQsIHdlYmluYXJJZCwgIHJlZ0RhdGEgKQo+PiAgICAgICAgICAgIHZhbHVlcyggIGNhc3QgKDpy ZXN1bHQgYXMgY2hhcigxKSksIDp3ZWJpbmFySWQsIDpyZXF1ZXN0ICk7Cj4+IAo+PiAKPj4gSm9u IFBhcmlzCj4+IAo+PiAtLQo+PiBUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkg KFJQRzQwMC1MKSBtYWlsaW5nIGxpc3QKPj4gVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQRzQw MC1MQGxpc3RzLm1pZHJhbmdlLmNvbQo+PiBUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBj aGFuZ2UgbGlzdCBvcHRpb25zLAo+PiB2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20v bWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbAo+PiBvciBlbWFpbDogUlBHNDAwLUwtcmVxdWVzdEBs aXN0cy5taWRyYW5nZS5jb20KPj4gQmVmb3JlIHBvc3RpbmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50 IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKPj4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNv bS9ycGc0MDAtbC4KPj4gCj4+IFBsZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5n ZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZCBxdWVzdGlvbnMuCj4+IAo+IC0tIAo+ IFRoaXMgaXMgdGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcg bGlzdAo+IFRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5j b20KPiBUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+ IHZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQw MC1sCj4gb3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gQmVm b3JlIHBvc3RpbmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMK PiBhdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgo+IAo+IFBsZWFzZSBj b250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24g cmVsYXRlZCBxdWVzdGlvbnMuCj4gCgotLSAKVGhpcyBpcyB0aGUgUlBHIHByb2dyYW1taW5nIG9u IElCTSBpIChSUEc0MDAtTCkgbWFpbGluZyBsaXN0ClRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBS UEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20KVG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3Ig Y2hhbmdlIGxpc3Qgb3B0aW9ucywKdmlzaXQ6IGh0dHBzOi8vbGlzdHMubWlkcmFuZ2UuY29tL21h aWxtYW4vbGlzdGluZm8vcnBnNDAwLWwKb3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMu bWlkcmFuZ2UuY29tCkJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZp ZXcgdGhlIGFyY2hpdmVzCmF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwu CgpQbGVhc2UgY29udGFjdCBzdXBwb3J0QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vi c2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgoK