Re: Weird SQL Problem
Vern Hamberg via RPG400-L <[email protected]> Mon, 4 May 2026 00:36:13 -0500
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
SGkgSm9uCgpNZW1vIHRvIFVzZXJzIGZvciA3LjUgaGFzIGluZm9ybWF0aW9uIG9uIHRoaXMgLQoK SW4gSUJNIGkgNy41LCBzdXBwb3J0IGZvciBhIG5hdGl2ZSBTUUwgQk9PTEVBTiBkYXRhIHR5cGUg d2FzIGFkZGVkIHRvIApEYjIgZm9yIGkuIFNpbmNlIHRoZSBCT09MRUFOIGRhdGEgdHlwZSBtYXRj aGVkIHRoZSBSUEcgaW5kaWNhdG9yIGRhdGEgCnR5cGUsIHRoZSBSUEcgcHJlY29tcGlsZXIgd2Fz IGNoYW5nZWQgdG8gZ2VuZXJhdGUgYW4gUlBHIGluZGljYXRvciBob3N0IAp2YXJpYWJsZSBhcyBh IEJPT0xFQU4uIEJlY2F1c2Ugb2YgdGhpcyBlbmhhbmNlbWVudCwgYW4gUlBHIHByb2dyYW0gd2l0 aCAKYW4gZW1iZWRkZWQgU1FMIHN0YXRlbWVudCB3aGljaCByZWZlcmVuY2VzIGFuIFJQRyBpbmRp Y2F0b3IgaG9zdCAKdmFyaWFibGUgbWF5IGhhdmUgZGlmZmVyZW50IGJlaGF2aW9yIHdoZW4gdGhl IFNRTCBwcm9ncmFtIGlzIHJlY29tcGlsZWQgCm9uIElCTSBpIDcuNS4gQW4gZW1iZWRkZWQgSU5T RVJULCBVUERBVEUsIE1FUkdFLCBTRVQsIG9yIFZBTFVFUyBJTlRPIFNRTCAKc3RhdGVtZW50IG1h eSBoYXZlIGRpZmZlcmVudCBiZWhhdmlvciB3aGVuIGFuIFJQRyBpbmRpY2F0b3IgaG9zdCAKdmFy aWFibGUgaXMgYXNzaWduZWQgaW50byBhIGNoYXJhY3RlciB2YXJpYWJsZSBvciBjaGFyYWN0ZXIg Y29sdW1uLiAKUHJpb3IgdG8gSUJNIGkgNy41LCB0aGUgdmFsdWUgJzAnIG9yICcxJyB3b3VsZCBi ZSBhc3NpZ25lZCwgYnV0IGluIElCTSBpIAo3LjUsIHRoZSB2YWx1ZSAnRkFMU0UnIG9yICdUUlVF ICcgaXMgYXNzaWduZWQuIFRoaXMgbWF5IGNhdXNlIGFuIFNRTDA0MDQgCm1lc3NhZ2UgKFNRTENP REUgLTQwNCkgb3IgU1FMMDMwMyBtZXNzYWdlIChTUUxDT0RFIC0zMDMpIHdoZW4gYW4gUlBHIApp bmRpY2F0b3IgaG9zdCB2YXJpYWJsZSBpcyBhc3NpZ25lZCBpbnRvIGEgY2hhcmFjdGVyIHZhcmlh YmxlIG9yIApjaGFyYWN0ZXIgY29sdW1uLgoKRXhpc3RpbmcgcHJvZ3JhbXMgd2hpY2ggYXJlIG5v dCByZWNvbXBpbGVkIGRvIG5vdCBjaGFuZ2UgYmVoYXZpb3IuIElmIAp0aGUgcHJldmlvdXMgYmVo YXZpb3IgaXMgcmVxdWlyZWQsIHRoZSBUR1RSTFMoKlBSViB8IFY3UjNNMCB8IFY3UjRNMCkgCnBh cmFtZXRlciBjYW4gYmUgdXNlZCBvbiB0aGUgQ3JlYXRlIFNRTCBJTEUgUlBHIE9iamVjdCAoQ1JU U1FMUlBHSSkgKkNNRC4KCkZvciBhZGRpdGlvbmFsIGluZm9ybWF0aW9uIG9uIHRoZSBTUUwgQk9P TEVBTiBkYXRhIHR5cGUsIHJlZmVyIHRvIApodHRwczovL3d3dy5pYm0uY29tL3N1cHBvcnQvcGFn ZXMvCm5vZGUvNjU3NTUzMS4KCipSZWdhcmRzKgoKKlZlcm4gSGFtYmVyZyoKCklCTSBDaGFtcGlv biAyMDI1IDxjaWQ6cGFydDEubkcyVFVlOUQuaTRFbTFObVpAY2VudHVyeWxpbmsubmV0PiBDQUFD IAooQ09NTU9OIEFtZXJpY2FzIEFkdmlzb3J5IENvdW5jaWwpIElCTSBJbmZsdWVuY2VyIDIwMjMK CgpPbiA1LzIvMjAyNiAxOjQzIFBNLCBKb24gUGFyaXMgd3JvdGU6Cj4gSSB1bmRlcnN0YW5kIGFs bCB0aGF0IERhbmllbCBidXQgdGhlIHVuZGVybHlpbmcgZGF0YSB0eXBlIGZvciBhbiBSUEcgaW5k aWNhdG9yIGhhcyBhbHdheXMgYmVlbiBjaGFyKDEpLgo+Cj4gUGVyaGFwcyBtb3JlIHRvIHRoZSBw b2ludDoKPgo+IDEpIGlmIHRoaXMgd2FzIGEgY29kaW5nIGVycm9yIG9uIG15IHBhcnQsIHRoZSBw cmUtY29tcGlsZXIgc2hvdWxkIHNwaXQgaXQgb3V0LiBOb3QgYWNjZXB0IGl0IGFuZCBzY3JldyB1 cCBhdCBydW4gdGltZS4KPgo+IDIpIFRoaXMgaGFzIGJlZW4gd29ya2luZyBzaW5jZSAyMDI0Cj4K PiAzKSBJZiBJIG1hbnVhbGx5IGNhc3QgdGhlIGluZGljYXRvciBJIG5vIGxvbmdlciBnZXQgYW4g ZXJyb3IgYnV0IHRoZSB2YWx1ZSByZXR1cm5lZCBpcyBub3QgemVybyBvciAxLiBJdCBpcyBjdXJy ZW50bHkgYSDigJxU4oCdIGZvciB0aGUgKk9uIGNvbmRpdGlvbi4KPgo+IDQpIFRoZSB0YWJsZSBo YXMgYmVlbiBhcm91bmQgZm9yIHNvbWUgdGltZSBhbmQgYSBidW5jaCBvZiBvdGhlciBzdHVmZiB3 b3VsZCBoYXZlIHRvIGNoYW5nZSBpZiBJIHN3aXRjaCBpdCB0byBib29sZWFuLiBJ4oCZZCByYXRo ZXIgYXZvaWQgdGhhdC4KPgo+IExvb2tzIGxpa2UgSeKAmW0gZ29pbmcgdG8gaGF2ZSB0byDigJxt YW51YWxseeKAnSBpbnRlcnByZXQgdGhlIGluZGljYXRvciBhbmQgcGFzcyB0aGUgcmVzdWx0aW5n IGNoYXIgZmllbGQgdG8gdGhlIFNRTC4KPgo+Cj4gSm9uIFBhcmlzCj4KPgo+PiBPbiBNYXkgMiwg MjAyNiwgYXQgMTQ6MjcsIERhbmllbCBHcm9zczxkYW5pZWxAcXBnbXIuZGU+IHdyb3RlOgo+Pgo+ PiBIaSBKb24sCj4+Cj4+IGlmIHlvdSB1c2UgYW4gaW5kaWNhdG9yIGZvciB0aGUgUkVTVUxUIGNv bHVtbiwgdGhlIG5hdHVyYWwgU1FMIGRhdGEgdHlwZSB3b3VsZCBiZSBCT09MRUFOLiBBbiBpbmRp Y2F0b3IgY2FuIG9ubHkgYmUgKk9OIG9yICpPRkYgLSBhIEJvb2xlYW4gY29sdW1uIGNhbiBvbmx5 IGJlIFRSVUUgKCpPTikgb3IgRkFMU0UgKCpPRkYpIC0gYW4gZW1iZWRkZWQgU1FMIGlzIGNvcnJl Y3RseSBjYXN0aW5nL2NvbnZlcnRpbmcgYmV0d2VlbiB0aG9zZSAyIGRhdGEgdHlwZXMuCj4+Cj4+ IEhUSAo+PiBEYW5pZWwKPj4KPj4KPj4+IEFtIDAyLjA1LjIwMjYgdW0gMjA6MTUgc2NocmllYiBK b24gUGFyaXM8am9uLnBhcmlzQHBhcnRuZXI0MDAuY29tPjoKPj4+Cj4+PiDvu79BcG9sb2dpZXMg aWYgdGhpcyBpcyBhIGR1cCBidXQgbXkgb3JpZ2luYWwgd2FzIHJlamVjdGVkIChJIHRoaW5rKSBh bmQgSSBjYW7igJl0IHNlZSBhbnl0aGluZyBmb3IgTWF5IGluIHRoZSBhcmNoaXZlcy4KPj4+Cj4+ PiBJIGhhdmUgYSB0YWJsZSBkZWZpbmVkIGFzOgo+Pj4KPj4+IFJFR0lTVEVSVElNRSBUSU1FU1RB TVAgTk9UIE5VTEwgREVGQVVMVCBDVVJSRU5UX1RJTUVTVEFNUCwKPj4+IFdFQklOQVJJRCBERUNJ TUFMKDExLCAwKSBOT1QgTlVMTCBERUZBVUxUIDAgLAo+Pj4gUkVTVUxUIENIQVIoMSkgTk9UIE5V TEwgREVGQVVMVCAnMCcgLAo+Pj4gUkVHSVNURVJEQVRBIFZBUkNIQVIoMTAwMCkgQUxMT0NBVEUo MzAwKSBDQ1NJRCAzNyBOT1QgTlVMTAo+Pj4KPj4+IFRoZSBTUUwgc3RhdGVtZW50IHRvIGluc2Vy dCB0aGUgZGF0YSBpczoKPj4+Cj4+PiBJbnNlcnQgaW50byB0YWJsZSAoIHdlYmluYXJJZCwgcmVz dWx0LCByZWdpc3RlckRhdGEgKQo+Pj4gICAgICAgICAgICAgdmFsdWVzKCA6d2ViaW5hcklkLCA6 cmVzdWx0LCA6cmVxdWVzdCApOwo+Pj4KPj4+IFdoZXJlIHRoZSBjb2x1bW5zIGFyZSBhbGwgZGVm aW5lZCBhcyBwZXIgdGhlIHRhYmxlIGRlZmluaXRpb24gLSBleGNlcHQgdGhhdCDigJxyZXN1bHTi gJ0gaW4gdGhlIFJQRyBjb2RlIGlzIGFuIGluZGljYXRvci4KPj4+Cj4+PiBUaGlzIGNvZGUgaGFz IGJlZW4gcnVubmluZyBmb3IgYSBjb3VwbGUgb2YgeWVhcnMgYnV0IHNpbmNlIG91ciBtb3ZlIHRv IDcuNiBoYXMgc3RhcnRlZCB0byBzb21ldGltZXMgdGhyb3cgU1FMQ09ERSAtNDA0IGFnYWluc3Qg dGhlIOKAnHJlc3VsdCIgY29sdW1uIGNsYWltaW5nIHRoYXQgaXRzIGxlbmd0aCBvZiA0IGV4Y2Vl ZHMgdGhlIGNhcGFjaXR5IG9mIHRoZSBjb2x1bW4uIEJ1dCBpdCBpc27igJl0IDQgbG9uZyBpdCBp cyAxLiBSdW5uaW5nIGluIGRlYnVnLCBJIGNhbiBzZWUgdGhhdCB0aGUgdGVtcCB2YXJpYWJsZSBm b3Ig4oCccmVzdWx04oCdIGNyZWF0ZWQgYnkgdGhlIHByZS1wcm9jZXNzb3IgaXMgY2hhcigxKS4K Pj4+Cj4+PiBOb3Qgc3VyZSB3aGVyZSBlbHNlIHRvIGxvb2suCj4+Pgo+Pj4gSSBoYXZlIGdvb2ds ZWQgZm9yIFBURnMgb3IgcmVwb3J0ZWQgZXJyb3JzIGJ1dCBhbSBub3Qgc2VlaW5nIGFueXRoaW5n Lgo+Pj4KPj4+IEFueW9uZSBnb3QgYW55IGlkZWFzIG9uIHdoZXJlIHRvIGxvb2sgbmV4dD8KPj4+ Cj4+PiBJIGhhdmUgYSB3b3JrIGFyb3VuZCAtIGlmIEkgZmFjZSB0aGUgY2FzdCBvZiB0aGUgaW5k aWNhdG9yIHRvIGNoYXIoMSkgaXQgd29ya3MuICBHdWVzcyB0aGVyZSBpcyBhIGJ1ZyBpbiB0aGUg Y29kZSBnZW5lcmF0ZWQgYnkgdGhlIHByZS1jb21waWxlci4KPj4+Cj4+PiBJbnNlcnQgaW50byBw YXJ0bmVyNDAwL3NxbHJlZ3Rlc3QgKCByZXN1bHQsIHdlYmluYXJJZCwgIHJlZ0RhdGEgKQo+Pj4g ICAgICAgICAgICAgdmFsdWVzKCAgY2FzdCAoOnJlc3VsdCBhcyBjaGFyKDEpKSwgOndlYmluYXJJ ZCwgOnJlcXVlc3QgKTsKPj4+Cj4+Pgo+Pj4gSm9uIFBhcmlzCj4+Pgo+Pj4gLS0KPj4+IFRoaXMg aXMgdGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+ Pj4gVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6UlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4+ PiBUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAo+Pj4g dmlzaXQ6aHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAt bAo+Pj4gb3IgZW1haWw6UlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KPj4+IEJl Zm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVz Cj4+PiBhdGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCj4+Pgo+Pj4gUGxl YXNlIGNvbnRhY3RzdXBwb3J0QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0 aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgo+Pj4KPj4gLS0gCj4+IFRoaXMgaXMgdGhlIFJQRyBwcm9n cmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+PiBUbyBwb3N0IGEgbWVz c2FnZSBlbWFpbDpSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20KPj4gVG8gc3Vic2NyaWJlLCB1 bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPj4gdmlzaXQ6aHR0cHM6Ly9saXN0 cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbAo+PiBvciBlbWFpbDpSUEc0 MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQo+PiBCZWZvcmUgcG9zdGluZywgcGxlYXNl IHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwo+PiBhdGh0dHBzOi8vYXJjaGl2 ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCj4+Cj4+IFBsZWFzZSBjb250YWN0c3VwcG9ydEBzdXBw b3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkIHF1ZXN0aW9ucy4K Pj4KLS0gClRoaXMgaXMgdGhlIFJQRyBwcm9ncmFtbWluZyBvbiBJQk0gaSAoUlBHNDAwLUwpIG1h aWxpbmcgbGlzdApUbyBwb3N0IGEgbWVzc2FnZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFu Z2UuY29tClRvIHN1YnNjcmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMs CnZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJhbmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQw MC1sCm9yIGVtYWlsOiBSUEc0MDAtTC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQpCZWZvcmUg cG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwphdCBo dHRwczovL2FyY2hpdmUubWlkcmFuZ2UuY29tL3JwZzQwMC1sLgoKUGxlYXNlIGNvbnRhY3Qgc3Vw cG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlvbiByZWxhdGVkIHF1 ZXN0aW9ucy4KCg==