Re: Weird SQL Problem

Jon Paris <[email protected]> Sat, 2 May 2026 17:03:41 -0400
Newsgroups gmane.comp.lang.as400.rpg
Message-ID <[email protected]>
V2VsbCB0aGUg4oCcZml44oCdIHdhcyB0aGlzIERhbmllbAoKRGNsLURTIFJlbWFwOyAgLy8gVXNl
ZCB0byByZW1hcCBpbmRpY2F0b3IgYXMgY2hhciBmaWVsZCBmb3IgbG9nZ2luZyAoU1FMIGJ1ZykK
ICAgcmVzdWx0ICAgICAgIEluZDsKICAgcmVzdWx0QyAgICAgIENoYXIoMSkgc2FtZXBvcyhyZXN1
bHQpOwpFbmQtRFM7CgpUaGVuIHVzaW5nIOKAnHJlc3VsdEMiIGluIHBsYWNlIG9mIOKAnHJlc3Vs
dCIgYXMgdGhlIGhvc3QgdmFyaWFibGUgYW5kIHRoYXQgZml4ZWQgaXQuCgpSZW1lbWJlciAtIGFz
IEkgc2FpZCBiZWZvcmUgLSB0aGlzIF9leGFjdF8gY29kZSBoYXMgYmVlbiBydW5uaW5nIHdpdGhv
dXQgZXJyb3JzIGZvciBhIGNvdXBsZSBvZiB5ZWFycy4gQmVjYXVzZSBvZiB0aGUgbmF0dXJlIG9m
IHRoZSBkYXRhIChhIGxvZyBvZiBlcnJvcnMpIHdl4oCZcmUgbm90IHN1cmUgZXhhY3RseSB3aGVu
IGl0IHN0b3BwZWQgd29ya2luZyBhcyB3ZSBoYWRu4oCZdCBuZWVkZWQgdG8gbG9vayBhdCB0aGUg
bG9nIHVudGlsIGFub3RoZXIgaXNzdWUgYXJvc2UgYSBmZXcgZGF5cyBhZ28uCgpJ4oCZbGwgYmUg
cmVwb3J0aW5nIHRoZSBlcnJvciB0byBJQk0uCgoKSm9uIFBhcmlzCgo+IE9uIE1heSAyLCAyMDI2
LCBhdCAxNToxMSwgRGFuaWVsIEdyb3NzIDxkYW5pZWxAcXBnbXIuZGU+IHdyb3RlOgo+IAo+IFdl
bGwgLSB5ZXMgLSBoaXN0b3JpY2FsbHkgYW4gaW5kaWNhdG9yIGlzIGEgQ0hBUigxKSBmaWVsZCwg
dGhhdCBvbmx5IGNhbiBiZSAnMCcgb3IgJzEnIC0gSSB0aGluayB0aGF0IHdhcyBvdXIgd2F5IGJh
Y2sgb24gcHVuY2hlZCBjYXJkcyA7LSkgLSB0b2RheSBCT09MRUFOIGlzIHRoZSBzYWZlIHdheSB0
byBnby4gQW5kIGluIGFuIGlkZWFsIHdvcmxkLCB0aGUgcHJlLWNvbXBpbGVyIHNob3VsZCBiZSBo
ZWxwZnVsIC0gYnV0IHdlIGxpdmUgd2l0aCBhbiBpbXBlcmZlY3QgcHJlLWNvbXBpbGVyIHNpbmNl
IGl0IGV4aXN0cy4KPiAKPiBBbmQgbm93IHRoYXQgeW91IHNheSBpdCAtIHRoZSBwaGVub21lbm9u
IHdpdGggdGhlICJUIiBhcyBhIHZhbHVlIGhhcyBvY2N1cnJlZCB0byBtZSB0b28gc29tZSB0aW1l
IGFnbyAtIGJ1dCBJIGNhbid0IHJlbWVtYmVyIHdoYXQgSSBoYXZlIGRvbmUgdG8gY3VyZSBpdC4g
UHJvYmFibHkgSSBhbHNvIENBU1RlZCBvciB1c2VkIGEgQ0FTRSBleHByZXNzaW9uLgo+IAo+IFRo
ZSBleHBsYW5hdGlvbiBmb3IgdGhhdCBwaGVub21lbm9uIHNlZW1zIHRvIHRoaXM6IGh0dHBzOi8v
d3d3LmlibS5jb20vZG9jcy9lbi9pLzcuNi4wP3RvcGljPXN0YXRlbWVudC1ib29sZWFuLWRhdGEt
dHlwZSAtIEkgcXVvdGUgZnJvbSB0aGUgcGFnZToKPiAKPj4gU3RyaW5nIHZhbHVlcyByZXByZXNl
bnRpbmcgdHJ1ZSBhcmUgJ3QnICwgJ3RydWUnICwgJ3knLCAneWVzJyAsICdvbicsIGFuZCAnMScu
IEZhbHNlIGNhbiBiZSByZXByZXNlbnRlZCBieSAnZicsICdmYWxzZScsICduJywgJ25vJywgJ29m
ZicsIGFuZCAnMCcuIEFueSBjb21iaW5hdGlvbiBvZiB1cHBlcmNhc2UgYW5kIGxvd2VyY2FzZSBj
aGFyYWN0ZXJzIGFyZSByZWNvZ25pemVkLgo+IAo+IFNvIC0gcHJvYmFibHkgdGhlIGluZGljYXRv
ciB2YWx1ZSAqT04gaXMgY29udmVydGVkIHRvICdUJyB3aGVuIHdyaXR0ZW4gdG8gdGhlIHRhYmxl
IHdpdGggU1FMIC0gYmVjYXVzZSBzaW5jZSBCT09MRUFOIGV4aXN0cyBhcyBhIGRhdGEgdHlwZSwg
aW5kaWNhdG9ycyBhcmUgdHJlYXRlZCBhcyBib29sZWFuIHZhbHVlcyBieSB0aGUgU1FMIGVuZ2lu
ZS4gQnV0IHRoaXMgaXMgcHVyZSBzcGVjdWxhdGlvbiBvbiBteSBzaWRlLgo+IAo+IENhbiB5b3Ug
bG9vayBpbnRvIHRoZSB0YWJsZSBkYXRhPyBNYXliZSBsb29rIGF0IHRoZSByb3dzLCB3aGVyZSB0
aGUgU1FMUlBHTEUgZmFpbHM/Cj4gCj4gUmVnYXJkcywKPiBEYW5pZWwKPiAKPiAKPiAKPj4gQW0g
MDIuMDUuMjAyNiB1bSAyMDo0NCBzY2hyaWViIEpvbiBQYXJpcyA8am9uLnBhcmlzQHBhcnRuZXI0
MDAuY29tPjoKPj4gCj4+IO+7v0kgdW5kZXJzdGFuZCBhbGwgdGhhdCBEYW5pZWwgYnV0IHRoZSB1
bmRlcmx5aW5nIGRhdGEgdHlwZSBmb3IgYW4gUlBHIGluZGljYXRvciBoYXMgYWx3YXlzIGJlZW4g
Y2hhcigxKS4KPj4gCj4+IFBlcmhhcHMgbW9yZSB0byB0aGUgcG9pbnQ6Cj4+IAo+PiAxKSBpZiB0
aGlzIHdhcyBhIGNvZGluZyBlcnJvciBvbiBteSBwYXJ0LCB0aGUgcHJlLWNvbXBpbGVyIHNob3Vs
ZCBzcGl0IGl0IG91dC4gTm90IGFjY2VwdCBpdCBhbmQgc2NyZXcgdXAgYXQgcnVuIHRpbWUuCj4+
IAo+PiAyKSBUaGlzIGhhcyBiZWVuIHdvcmtpbmcgc2luY2UgMjAyNAo+PiAKPj4gMykgSWYgSSBt
YW51YWxseSBjYXN0IHRoZSBpbmRpY2F0b3IgSSBubyBsb25nZXIgZ2V0IGFuIGVycm9yIGJ1dCB0
aGUgdmFsdWUgcmV0dXJuZWQgaXMgbm90IHplcm8gb3IgMS4gSXQgaXMgY3VycmVudGx5IGEg4oCc
VOKAnSBmb3IgdGhlICpPbiBjb25kaXRpb24uCj4+IAo+PiA0KSBUaGUgdGFibGUgaGFzIGJlZW4g
YXJvdW5kIGZvciBzb21lIHRpbWUgYW5kIGEgYnVuY2ggb2Ygb3RoZXIgc3R1ZmYgd291bGQgaGF2
ZSB0byBjaGFuZ2UgaWYgSSBzd2l0Y2ggaXQgdG8gYm9vbGVhbi4gSeKAmWQgcmF0aGVyIGF2b2lk
IHRoYXQuCj4+IAo+PiBMb29rcyBsaWtlIEnigJltIGdvaW5nIHRvIGhhdmUgdG8g4oCcbWFudWFs
bHnigJ0gaW50ZXJwcmV0IHRoZSBpbmRpY2F0b3IgYW5kIHBhc3MgdGhlIHJlc3VsdGluZyBjaGFy
IGZpZWxkIHRvIHRoZSBTUUwuCj4+IAo+PiAKPj4gSm9uIFBhcmlzCj4+IAo+PiAKPj4+IE9uIE1h
eSAyLCAyMDI2LCBhdCAxNDoyNywgRGFuaWVsIEdyb3NzIDxkYW5pZWxAcXBnbXIuZGU+IHdyb3Rl
Ogo+Pj4gSGkgSm9uLAo+Pj4gaWYgeW91IHVzZSBhbiBpbmRpY2F0b3IgZm9yIHRoZSBSRVNVTFQg
Y29sdW1uLCB0aGUgbmF0dXJhbCBTUUwgZGF0YSB0eXBlIHdvdWxkIGJlIEJPT0xFQU4uIEFuIGlu
ZGljYXRvciBjYW4gb25seSBiZSAqT04gb3IgKk9GRiAtIGEgQm9vbGVhbiBjb2x1bW4gY2FuIG9u
bHkgYmUgVFJVRSAoKk9OKSBvciBGQUxTRSAoKk9GRikgLSBhbiBlbWJlZGRlZCBTUUwgaXMgY29y
cmVjdGx5IGNhc3RpbmcvY29udmVydGluZyBiZXR3ZWVuIHRob3NlIDIgZGF0YSB0eXBlcy4KPj4+
IEhUSAo+Pj4gRGFuaWVsCj4+Pj4+IEFtIDAyLjA1LjIwMjYgdW0gMjA6MTUgc2NocmllYiBKb24g
UGFyaXMgPGpvbi5wYXJpc0BwYXJ0bmVyNDAwLmNvbT46Cj4+Pj4g77u/QXBvbG9naWVzIGlmIHRo
aXMgaXMgYSBkdXAgYnV0IG15IG9yaWdpbmFsIHdhcyByZWplY3RlZCAoSSB0aGluaykgYW5kIEkg
Y2Fu4oCZdCBzZWUgYW55dGhpbmcgZm9yIE1heSBpbiB0aGUgYXJjaGl2ZXMuCj4+Pj4gSSBoYXZl
IGEgdGFibGUgZGVmaW5lZCBhczoKPj4+PiBSRUdJU1RFUlRJTUUgVElNRVNUQU1QIE5PVCBOVUxM
IERFRkFVTFQgQ1VSUkVOVF9USU1FU1RBTVAsCj4+Pj4gV0VCSU5BUklEIERFQ0lNQUwoMTEsIDAp
IE5PVCBOVUxMIERFRkFVTFQgMCAsCj4+Pj4gUkVTVUxUIENIQVIoMSkgTk9UIE5VTEwgREVGQVVM
VCAnMCcgLAo+Pj4+IFJFR0lTVEVSREFUQSBWQVJDSEFSKDEwMDApIEFMTE9DQVRFKDMwMCkgQ0NT
SUQgMzcgTk9UIE5VTEwKPj4+PiBUaGUgU1FMIHN0YXRlbWVudCB0byBpbnNlcnQgdGhlIGRhdGEg
aXM6Cj4+Pj4gSW5zZXJ0IGludG8gdGFibGUgKCB3ZWJpbmFySWQsIHJlc3VsdCwgcmVnaXN0ZXJE
YXRhICkKPj4+PiAgICAgICAgIHZhbHVlcyggOndlYmluYXJJZCwgOnJlc3VsdCwgOnJlcXVlc3Qg
KTsKPj4+PiBXaGVyZSB0aGUgY29sdW1ucyBhcmUgYWxsIGRlZmluZWQgYXMgcGVyIHRoZSB0YWJs
ZSBkZWZpbml0aW9uIC0gZXhjZXB0IHRoYXQg4oCccmVzdWx04oCdIGluIHRoZSBSUEcgY29kZSBp
cyBhbiBpbmRpY2F0b3IuCj4+Pj4gVGhpcyBjb2RlIGhhcyBiZWVuIHJ1bm5pbmcgZm9yIGEgY291
cGxlIG9mIHllYXJzIGJ1dCBzaW5jZSBvdXIgbW92ZSB0byA3LjYgaGFzIHN0YXJ0ZWQgdG8gc29t
ZXRpbWVzIHRocm93IFNRTENPREUgLTQwNCBhZ2FpbnN0IHRoZSDigJxyZXN1bHQiIGNvbHVtbiBj
bGFpbWluZyB0aGF0IGl0cyBsZW5ndGggb2YgNCBleGNlZWRzIHRoZSBjYXBhY2l0eSBvZiB0aGUg
Y29sdW1uLiBCdXQgaXQgaXNu4oCZdCA0IGxvbmcgaXQgaXMgMS4gUnVubmluZyBpbiBkZWJ1Zywg
SSBjYW4gc2VlIHRoYXQgdGhlIHRlbXAgdmFyaWFibGUgZm9yIOKAnHJlc3VsdOKAnSBjcmVhdGVk
IGJ5IHRoZSBwcmUtcHJvY2Vzc29yIGlzIGNoYXIoMSkuCj4+Pj4gTm90IHN1cmUgd2hlcmUgZWxz
ZSB0byBsb29rLgo+Pj4+IEkgaGF2ZSBnb29nbGVkIGZvciBQVEZzIG9yIHJlcG9ydGVkIGVycm9y
cyBidXQgYW0gbm90IHNlZWluZyBhbnl0aGluZy4KPj4+PiBBbnlvbmUgZ290IGFueSBpZGVhcyBv
biB3aGVyZSB0byBsb29rIG5leHQ/Cj4+Pj4gSSBoYXZlIGEgd29yayBhcm91bmQgLSBpZiBJIGZh
Y2UgdGhlIGNhc3Qgb2YgdGhlIGluZGljYXRvciB0byBjaGFyKDEpIGl0IHdvcmtzLiAgR3Vlc3Mg
dGhlcmUgaXMgYSBidWcgaW4gdGhlIGNvZGUgZ2VuZXJhdGVkIGJ5IHRoZSBwcmUtY29tcGlsZXIu
Cj4+Pj4gSW5zZXJ0IGludG8gcGFydG5lcjQwMC9zcWxyZWd0ZXN0ICggcmVzdWx0LCB3ZWJpbmFy
SWQsICByZWdEYXRhICkKPj4+PiAgICAgICAgIHZhbHVlcyggIGNhc3QgKDpyZXN1bHQgYXMgY2hh
cigxKSksIDp3ZWJpbmFySWQsIDpyZXF1ZXN0ICk7Cj4+Pj4gSm9uIFBhcmlzCj4+Pj4gLS0KPj4+
PiBUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5n
IGxpc3QKPj4+PiBUbyBwb3N0IGEgbWVzc2FnZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFu
Z2UuY29tCj4+Pj4gVG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0
aW9ucywKPj4+PiB2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0
aW5mby9ycGc0MDAtbAo+Pj4+IG9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJh
bmdlLmNvbQo+Pj4+IEJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZp
ZXcgdGhlIGFyY2hpdmVzCj4+Pj4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0
MDAtbC4KPj4+PiBQbGVhc2UgY29udGFjdCBzdXBwb3J0QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZv
ciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgo+Pj4gLS0KPj4+IFRoaXMgaXMg
dGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+Pj4g
VG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQRzQwMC1MQGxpc3RzLm1pZHJhbmdlLmNvbQo+Pj4g
VG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPj4+IHZp
c2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1s
Cj4+PiBvciBlbWFpbDogUlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KPj4+IEJl
Zm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVz
Cj4+PiBhdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgo+Pj4gUGxlYXNl
IGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlv
biByZWxhdGVkIHF1ZXN0aW9ucy4KPj4gCj4+IC0tCj4+IFRoaXMgaXMgdGhlIFJQRyBwcm9ncmFt
bWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+PiBUbyBwb3N0IGEgbWVzc2Fn
ZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4+IFRvIHN1YnNjcmliZSwgdW5z
dWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCj4+IHZpc2l0OiBodHRwczovL2xpc3Rz
Lm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sCj4+IG9yIGVtYWlsOiBSUEc0
MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQo+PiBCZWZvcmUgcG9zdGluZywgcGxlYXNl
IHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwo+PiBhdCBodHRwczovL2FyY2hp
dmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgo+PiAKPj4gUGxlYXNlIGNvbnRhY3Qgc3VwcG9ydEBz
dXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkIHF1ZXN0aW9u
cy4KPiAKPiAtLSAKPiBUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkgKFJQRzQw
MC1MKSBtYWlsaW5nIGxpc3QKPiBUbyBwb3N0IGEgbWVzc2FnZSBlbWFpbDogUlBHNDAwLUxAbGlz
dHMubWlkcmFuZ2UuY29tCj4gVG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxp
c3Qgb3B0aW9ucywKPiB2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9s
aXN0aW5mby9ycGc0MDAtbAo+IG9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJh
bmdlLmNvbQo+IEJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcg
dGhlIGFyY2hpdmVzCj4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0MDAtbC4K
PiAKPiBQbGVhc2UgY29udGFjdCBzdXBwb3J0QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZvciBhbnkg
c3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgo+IAoKLS0gClRoaXMgaXMgdGhlIFJQRyBw
cm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdApUbyBwb3N0IGEgbWVz
c2FnZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tClRvIHN1YnNjcmliZSwgdW5z
dWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCnZpc2l0OiBodHRwczovL2xpc3RzLm1p
ZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sCm9yIGVtYWlsOiBSUEc0MDAtTC1y
ZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQpCZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBt
b21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwphdCBodHRwczovL2FyY2hpdmUubWlkcmFuZ2Uu
Y29tL3JwZzQwMC1sLgoKUGxlYXNlIGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNv
bSBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkIHF1ZXN0aW9ucy4KCg==