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=