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==