Re: Weird SQL Problem
Jim Franz <[email protected]> Sat, 2 May 2026 16:24:29 -0400
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <CAEVZ15Nxz3A75J8XYWD8kSXWezKDUPX+_u01gUYiSF476aRMMQ@mail.gmail.com> |
MS4gZG9lcyB0aGUgY29tcGlsZXIgbGlzdGluZyAoYW5kIHByZS1jb21waWxlciBsaXN0aW5nIGlm IHlvdSBzZWxlY3QgdGhhdApvcHRpb24pIG9mZmVyIGFueSBjbHVlcywgc2hvd2luZyBsZW5ndGgg PwoyLiBkb2VzIGl0IG1hdHRlciB0aGF0ICJyZXN1bHQiIGlzIGEgcmVzZXJ2ZWQgd29yZCBpbiBE QjIgKGFsdGhvdWdoIHdpa2kKbm90IHNwZWNpZmljIGFib3V0IHdoaWNoIHZlcnNpb24gb2YgREIy KQoKaHR0cHM6Ly9lbi53aWtpcGVkaWEub3JnL3dpa2kvTGlzdF9vZl9TUUxfcmVzZXJ2ZWRfd29y ZHMjOn46dGV4dD1UaGlzJTIwbGlzdCUyMGluY2x1ZGVzJTIwU1FMJTIwcmVzZXJ2ZWQsYW5kJTIw c29tZSUyMFJEQk1TcyUyMGhhdmUlMjBhZGRlZAouCgpKaW0gRnJhbnoKCk9uIFNhdCwgTWF5IDIs IDIwMjYgYXQgMzoxMuKAr1BNIERhbmllbCBHcm9zcyA8ZGFuaWVsQHFwZ21yLmRlPiB3cm90ZToK Cj4gV2VsbCAtIHllcyAtIGhpc3RvcmljYWxseSBhbiBpbmRpY2F0b3IgaXMgYSBDSEFSKDEpIGZp ZWxkLCB0aGF0IG9ubHkgY2FuCj4gYmUgJzAnIG9yICcxJyAtIEkgdGhpbmsgdGhhdCB3YXMgb3Vy IHdheSBiYWNrIG9uIHB1bmNoZWQgY2FyZHMgOy0pIC0gdG9kYXkKPiBCT09MRUFOIGlzIHRoZSBz YWZlIHdheSB0byBnby4gQW5kIGluIGFuIGlkZWFsIHdvcmxkLCB0aGUgcHJlLWNvbXBpbGVyCj4g c2hvdWxkIGJlIGhlbHBmdWwgLSBidXQgd2UgbGl2ZSB3aXRoIGFuIGltcGVyZmVjdCBwcmUtY29t cGlsZXIgc2luY2UgaXQKPiBleGlzdHMuCj4KPiBBbmQgbm93IHRoYXQgeW91IHNheSBpdCAtIHRo ZSBwaGVub21lbm9uIHdpdGggdGhlICJUIiBhcyBhIHZhbHVlIGhhcwo+IG9jY3VycmVkIHRvIG1l IHRvbyBzb21lIHRpbWUgYWdvIC0gYnV0IEkgY2FuJ3QgcmVtZW1iZXIgd2hhdCBJIGhhdmUgZG9u ZSB0bwo+IGN1cmUgaXQuIFByb2JhYmx5IEkgYWxzbyBDQVNUZWQgb3IgdXNlZCBhIENBU0UgZXhw cmVzc2lvbi4KPgo+IFRoZSBleHBsYW5hdGlvbiBmb3IgdGhhdCBwaGVub21lbm9uIHNlZW1zIHRv IHRoaXM6Cj4gaHR0cHM6Ly93d3cuaWJtLmNvbS9kb2NzL2VuL2kvNy42LjA/dG9waWM9c3RhdGVt ZW50LWJvb2xlYW4tZGF0YS10eXBlIC0gSQo+IHF1b3RlIGZyb20gdGhlIHBhZ2U6Cj4KPiA+IFN0 cmluZyB2YWx1ZXMgcmVwcmVzZW50aW5nIHRydWUgYXJlICd0JyAsICd0cnVlJyAsICd5JywgJ3ll cycgLCAnb24nLAo+IGFuZCAnMScuIEZhbHNlIGNhbiBiZSByZXByZXNlbnRlZCBieSAnZicsICdm YWxzZScsICduJywgJ25vJywgJ29mZicsIGFuZAo+ICcwJy4gQW55IGNvbWJpbmF0aW9uIG9mIHVw cGVyY2FzZSBhbmQgbG93ZXJjYXNlIGNoYXJhY3RlcnMgYXJlIHJlY29nbml6ZWQuCj4KPiBTbyAt IHByb2JhYmx5IHRoZSBpbmRpY2F0b3IgdmFsdWUgKk9OIGlzIGNvbnZlcnRlZCB0byAnVCcgd2hl biB3cml0dGVuIHRvCj4gdGhlIHRhYmxlIHdpdGggU1FMIC0gYmVjYXVzZSBzaW5jZSBCT09MRUFO IGV4aXN0cyBhcyBhIGRhdGEgdHlwZSwKPiBpbmRpY2F0b3JzIGFyZSB0cmVhdGVkIGFzIGJvb2xl YW4gdmFsdWVzIGJ5IHRoZSBTUUwgZW5naW5lLiBCdXQgdGhpcyBpcwo+IHB1cmUgc3BlY3VsYXRp b24gb24gbXkgc2lkZS4KPgo+IENhbiB5b3UgbG9vayBpbnRvIHRoZSB0YWJsZSBkYXRhPyBNYXli ZSBsb29rIGF0IHRoZSByb3dzLCB3aGVyZSB0aGUKPiBTUUxSUEdMRSBmYWlscz8KPgo+IFJlZ2Fy ZHMsCj4gRGFuaWVsCj4KPgo+Cj4gPiBBbSAwMi4wNS4yMDI2IHVtIDIwOjQ0IHNjaHJpZWIgSm9u IFBhcmlzIDxqb24ucGFyaXNAcGFydG5lcjQwMC5jb20+Ogo+ID4KPiA+IO+7v0kgdW5kZXJzdGFu ZCBhbGwgdGhhdCBEYW5pZWwgYnV0IHRoZSB1bmRlcmx5aW5nIGRhdGEgdHlwZSBmb3IgYW4gUlBH Cj4gaW5kaWNhdG9yIGhhcyBhbHdheXMgYmVlbiBjaGFyKDEpLgo+ID4KPiA+IFBlcmhhcHMgbW9y ZSB0byB0aGUgcG9pbnQ6Cj4gPgo+ID4gMSkgaWYgdGhpcyB3YXMgYSBjb2RpbmcgZXJyb3Igb24g bXkgcGFydCwgdGhlIHByZS1jb21waWxlciBzaG91bGQgc3BpdAo+IGl0IG91dC4gTm90IGFjY2Vw dCBpdCBhbmQgc2NyZXcgdXAgYXQgcnVuIHRpbWUuCj4gPgo+ID4gMikgVGhpcyBoYXMgYmVlbiB3 b3JraW5nIHNpbmNlIDIwMjQKPiA+Cj4gPiAzKSBJZiBJIG1hbnVhbGx5IGNhc3QgdGhlIGluZGlj YXRvciBJIG5vIGxvbmdlciBnZXQgYW4gZXJyb3IgYnV0IHRoZQo+IHZhbHVlIHJldHVybmVkIGlz IG5vdCB6ZXJvIG9yIDEuIEl0IGlzIGN1cnJlbnRseSBhIOKAnFTigJ0gZm9yIHRoZSAqT24KPiBj b25kaXRpb24uCj4gPgo+ID4gNCkgVGhlIHRhYmxlIGhhcyBiZWVuIGFyb3VuZCBmb3Igc29tZSB0 aW1lIGFuZCBhIGJ1bmNoIG9mIG90aGVyIHN0dWZmCj4gd291bGQgaGF2ZSB0byBjaGFuZ2UgaWYg SSBzd2l0Y2ggaXQgdG8gYm9vbGVhbi4gSeKAmWQgcmF0aGVyIGF2b2lkIHRoYXQuCj4gPgo+ID4g TG9va3MgbGlrZSBJ4oCZbSBnb2luZyB0byBoYXZlIHRvIOKAnG1hbnVhbGx54oCdIGludGVycHJl dCB0aGUgaW5kaWNhdG9yIGFuZAo+IHBhc3MgdGhlIHJlc3VsdGluZyBjaGFyIGZpZWxkIHRvIHRo ZSBTUUwuCj4gPgo+ID4KPiA+IEpvbiBQYXJpcwo+ID4KPiA+Cj4gPj4gT24gTWF5IDIsIDIwMjYs IGF0IDE0OjI3LCBEYW5pZWwgR3Jvc3MgPGRhbmllbEBxcGdtci5kZT4gd3JvdGU6Cj4gPj4gSGkg Sm9uLAo+ID4+IGlmIHlvdSB1c2UgYW4gaW5kaWNhdG9yIGZvciB0aGUgUkVTVUxUIGNvbHVtbiwg dGhlIG5hdHVyYWwgU1FMIGRhdGEKPiB0eXBlIHdvdWxkIGJlIEJPT0xFQU4uIEFuIGluZGljYXRv ciBjYW4gb25seSBiZSAqT04gb3IgKk9GRiAtIGEgQm9vbGVhbgo+IGNvbHVtbiBjYW4gb25seSBi ZSBUUlVFICgqT04pIG9yIEZBTFNFICgqT0ZGKSAtIGFuIGVtYmVkZGVkIFNRTCBpcwo+IGNvcnJl Y3RseSBjYXN0aW5nL2NvbnZlcnRpbmcgYmV0d2VlbiB0aG9zZSAyIGRhdGEgdHlwZXMuCj4gPj4g SFRICj4gPj4gRGFuaWVsCj4gPj4+PiBBbSAwMi4wNS4yMDI2IHVtIDIwOjE1IHNjaHJpZWIgSm9u IFBhcmlzIDxqb24ucGFyaXNAcGFydG5lcjQwMC5jb20+Ogo+ID4+PiDvu79BcG9sb2dpZXMgaWYg dGhpcyBpcyBhIGR1cCBidXQgbXkgb3JpZ2luYWwgd2FzIHJlamVjdGVkIChJIHRoaW5rKSBhbmQK PiBJIGNhbuKAmXQgc2VlIGFueXRoaW5nIGZvciBNYXkgaW4gdGhlIGFyY2hpdmVzLgo+ID4+PiBJ IGhhdmUgYSB0YWJsZSBkZWZpbmVkIGFzOgo+ID4+PiBSRUdJU1RFUlRJTUUgVElNRVNUQU1QIE5P VCBOVUxMIERFRkFVTFQgQ1VSUkVOVF9USU1FU1RBTVAsCj4gPj4+IFdFQklOQVJJRCBERUNJTUFM KDExLCAwKSBOT1QgTlVMTCBERUZBVUxUIDAgLAo+ID4+PiBSRVNVTFQgQ0hBUigxKSBOT1QgTlVM TCBERUZBVUxUICcwJyAsCj4gPj4+IFJFR0lTVEVSREFUQSBWQVJDSEFSKDEwMDApIEFMTE9DQVRF KDMwMCkgQ0NTSUQgMzcgTk9UIE5VTEwKPiA+Pj4gVGhlIFNRTCBzdGF0ZW1lbnQgdG8gaW5zZXJ0 IHRoZSBkYXRhIGlzOgo+ID4+PiBJbnNlcnQgaW50byB0YWJsZSAoIHdlYmluYXJJZCwgcmVzdWx0 LCByZWdpc3RlckRhdGEgKQo+ID4+PiAgICAgICAgICB2YWx1ZXMoIDp3ZWJpbmFySWQsIDpyZXN1 bHQsIDpyZXF1ZXN0ICk7Cj4gPj4+IFdoZXJlIHRoZSBjb2x1bW5zIGFyZSBhbGwgZGVmaW5lZCBh cyBwZXIgdGhlIHRhYmxlIGRlZmluaXRpb24gLSBleGNlcHQKPiB0aGF0IOKAnHJlc3VsdOKAnSBp biB0aGUgUlBHIGNvZGUgaXMgYW4gaW5kaWNhdG9yLgo+ID4+PiBUaGlzIGNvZGUgaGFzIGJlZW4g cnVubmluZyBmb3IgYSBjb3VwbGUgb2YgeWVhcnMgYnV0IHNpbmNlIG91ciBtb3ZlIHRvCj4gNy42 IGhhcyBzdGFydGVkIHRvIHNvbWV0aW1lcyB0aHJvdyBTUUxDT0RFIC00MDQgYWdhaW5zdCB0aGUg 4oCccmVzdWx0IiBjb2x1bW4KPiBjbGFpbWluZyB0aGF0IGl0cyBsZW5ndGggb2YgNCBleGNlZWRz IHRoZSBjYXBhY2l0eSBvZiB0aGUgY29sdW1uLiBCdXQgaXQKPiBpc27igJl0IDQgbG9uZyBpdCBp cyAxLiBSdW5uaW5nIGluIGRlYnVnLCBJIGNhbiBzZWUgdGhhdCB0aGUgdGVtcCB2YXJpYWJsZQo+ IGZvciDigJxyZXN1bHTigJ0gY3JlYXRlZCBieSB0aGUgcHJlLXByb2Nlc3NvciBpcyBjaGFyKDEp Lgo+ID4+PiBOb3Qgc3VyZSB3aGVyZSBlbHNlIHRvIGxvb2suCj4gPj4+IEkgaGF2ZSBnb29nbGVk IGZvciBQVEZzIG9yIHJlcG9ydGVkIGVycm9ycyBidXQgYW0gbm90IHNlZWluZyBhbnl0aGluZy4K PiA+Pj4gQW55b25lIGdvdCBhbnkgaWRlYXMgb24gd2hlcmUgdG8gbG9vayBuZXh0Pwo+ID4+PiBJ IGhhdmUgYSB3b3JrIGFyb3VuZCAtIGlmIEkgZmFjZSB0aGUgY2FzdCBvZiB0aGUgaW5kaWNhdG9y IHRvIGNoYXIoMSkKPiBpdCB3b3Jrcy4gIEd1ZXNzIHRoZXJlIGlzIGEgYnVnIGluIHRoZSBjb2Rl IGdlbmVyYXRlZCBieSB0aGUgcHJlLWNvbXBpbGVyLgo+ID4+PiBJbnNlcnQgaW50byBwYXJ0bmVy NDAwL3NxbHJlZ3Rlc3QgKCByZXN1bHQsIHdlYmluYXJJZCwgIHJlZ0RhdGEgKQo+ID4+PiAgICAg ICAgICB2YWx1ZXMoICBjYXN0ICg6cmVzdWx0IGFzIGNoYXIoMSkpLCA6d2ViaW5hcklkLCA6cmVx dWVzdCApOwo+ID4+PiBKb24gUGFyaXMKPiA+Pj4gLS0KPiA+Pj4gVGhpcyBpcyB0aGUgUlBHIHBy b2dyYW1taW5nIG9uIElCTSBpIChSUEc0MDAtTCkgbWFpbGluZyBsaXN0Cj4gPj4+IFRvIHBvc3Qg YSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20KPiA+Pj4gVG8gc3Vi c2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPiA+Pj4gdmlzaXQ6 IGh0dHBzOi8vbGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vcnBnNDAwLWwKPiA+ Pj4gb3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gPj4+IEJl Zm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVz Cj4gPj4+IGF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCj4gPj4+IFBs ZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3Jp cHRpb24KPiByZWxhdGVkIHF1ZXN0aW9ucy4KPiA+PiAtLQo+ID4+IFRoaXMgaXMgdGhlIFJQRyBw cm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+ID4+IFRvIHBvc3Qg YSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20KPiA+PiBUbyBzdWJz Y3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+ID4+IHZpc2l0OiBo dHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sCj4gPj4g b3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4gPj4gQmVmb3Jl IHBvc3RpbmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKPiA+ PiBhdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgo+ID4+IFBsZWFzZSBj b250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24K PiByZWxhdGVkIHF1ZXN0aW9ucy4KPiA+Cj4gPiAtLQo+ID4gVGhpcyBpcyB0aGUgUlBHIHByb2dy YW1taW5nIG9uIElCTSBpIChSUEc0MDAtTCkgbWFpbGluZyBsaXN0Cj4gPiBUbyBwb3N0IGEgbWVz c2FnZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4gPiBUbyBzdWJzY3JpYmUs IHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+ID4gdmlzaXQ6IGh0dHBzOi8v bGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vcnBnNDAwLWwKPiA+IG9yIGVtYWls OiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQo+ID4gQmVmb3JlIHBvc3Rpbmcs IHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKPiA+IGF0IGh0dHBz Oi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCj4gPgo+ID4gUGxlYXNlIGNvbnRhY3Qg c3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlvbgo+IHJlbGF0 ZWQgcXVlc3Rpb25zLgo+Cj4gLS0KPiBUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJN IGkgKFJQRzQwMC1MKSBtYWlsaW5nIGxpc3QKPiBUbyBwb3N0IGEgbWVzc2FnZSBlbWFpbDogUlBH NDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4gVG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3Ig Y2hhbmdlIGxpc3Qgb3B0aW9ucywKPiB2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20v bWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbAo+IG9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxp c3RzLm1pZHJhbmdlLmNvbQo+IEJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0 byByZXZpZXcgdGhlIGFyY2hpdmVzCj4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9y cGc0MDAtbC4KPgo+IFBsZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20g Zm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZAo+IHF1ZXN0aW9ucy4KPgo+Ci0tIApUaGlzIGlz IHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5nIGxpc3QKVG8g cG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQRzQwMC1MQGxpc3RzLm1pZHJhbmdlLmNvbQpUbyBzdWJz Y3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAp2aXNpdDogaHR0cHM6 Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbApvciBlbWFpbDog UlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KQmVmb3JlIHBvc3RpbmcsIHBsZWFz ZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKYXQgaHR0cHM6Ly9hcmNoaXZl Lm1pZHJhbmdlLmNvbS9ycGc0MDAtbC4KClBsZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5t aWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZCBxdWVzdGlvbnMuCgo=