RE: Weird SQL Problem
"Birgitta Hauser" <Hauser-bRAHsVz2yv4TVIZRl6KS/[email protected]> Sun, 3 May 2026 12:25:39 +0200
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
SXQgbXVzdCBiZSBhIGJ1ZyEKQWNjb3JkaW5nIHRvIHRoZSBkb2N1bWVudGF0aW9uIHRoZSBlcXVp dmFsZW50IGZvciB0aGUgQk9PTEVBTiBkYXRhIHR5cGUgaW4gU1FMIGlzIHRoZSBJTkQgZGF0YSB0 eXBlIGluIChlbWJlZGRlZCkgUlBHLgpJJ2QgcmVwb3J0IGl0IHRvIElCTQoKTWl0IGZyZXVuZGxp Y2hlbiBHcsO8w59lbiAvIEJlc3QgcmVnYXJkcwoKQmlyZ2l0dGEgSGF1c2VyCk1vZGVybml6YXRp b24g4oCTIEVkdWNhdGlvbiDigJMgQ29uc3VsdGluZyBvbiBJQk0gaQpEYXRhYmFzZSBhbmQgU29m dHdhcmUgQXJjaGl0ZWN0ICAKSUJNIENoYW1waW9uIHNpbmNlIDIwMjAKCiJTaG9vdCBmb3IgdGhl IG1vb24sIGV2ZW4gaWYgeW91IG1pc3MsIHlvdSdsbCBsYW5kIGFtb25nIHRoZSBzdGFycy4iIChM ZXMgQnJvd24pCiJJZiB5b3UgdGhpbmsgZWR1Y2F0aW9uIGlzIGV4cGVuc2l2ZSwgdHJ5IGlnbm9y YW5jZS4iIChEZXJlayBCb2spCiJXaGF0IGlzIHdvcnNlIHRoYW4gdHJhaW5pbmcgeW91ciBzdGFm ZiBhbmQgbG9zaW5nIHRoZW0/IE5vdCB0cmFpbmluZyB0aGVtIGFuZCBrZWVwaW5nIHRoZW0hIgoi VHJhaW4gcGVvcGxlIHdlbGwgZW5vdWdoIHNvIHRoZXkgY2FuIGxlYXZlLCB0cmVhdCB0aGVtIHdl bGwgZW5vdWdoIHNvIHRoZXkgZG9uJ3Qgd2FudCB0by4gIiAoUmljaGFyZCBCcmFuc29uKQoiTGVh cm5pbmcgaXMgZXhwZXJpZW5jZSDigKYgZXZlcnl0aGluZyBlbHNlIGlzIG9ubHkgaW5mb3JtYXRp b24hIiAoQWxiZXJ0IEVpbnN0ZWluKQoKCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tCkZyb206 IFJQRzQwMC1MIDxycGc0MDAtbC1ib3VuY2VzQGxpc3RzLm1pZHJhbmdlLmNvbT4gT24gQmVoYWxm IE9mIEpvbiBQYXJpcwpTZW50OiBTYXR1cmRheSwgMiBNYXkgMjAyNiAyMDoxNApUbzogUlBHIHBy b2dyYW1taW5nIG9uIHRoZSBJQk0gaSAoQVMvNDAwIGFuZCBpU2VyaWVzKSA8cnBnNDAwLWxAbGlz dHMubWlkcmFuZ2UuY29tPgpTdWJqZWN0OiBXZWlyZCBTUUwgUHJvYmxlbQoKQXBvbG9naWVzIGlm IHRoaXMgaXMgYSBkdXAgYnV0IG15IG9yaWdpbmFsIHdhcyByZWplY3RlZCAoSSB0aGluaykgYW5k IEkgY2Fu4oCZdCBzZWUgYW55dGhpbmcgZm9yIE1heSBpbiB0aGUgYXJjaGl2ZXMuCgpJIGhhdmUg YSB0YWJsZSBkZWZpbmVkIGFzOgoKUkVHSVNURVJUSU1FIFRJTUVTVEFNUCBOT1QgTlVMTCBERUZB VUxUIENVUlJFTlRfVElNRVNUQU1QLCBXRUJJTkFSSUQgREVDSU1BTCgxMSwgMCkgTk9UIE5VTEwg REVGQVVMVCAwICwgUkVTVUxUIENIQVIoMSkgTk9UIE5VTEwgREVGQVVMVCAnMCcgLCBSRUdJU1RF UkRBVEEgVkFSQ0hBUigxMDAwKSBBTExPQ0FURSgzMDApIENDU0lEIDM3IE5PVCBOVUxMIAoKVGhl IFNRTCBzdGF0ZW1lbnQgdG8gaW5zZXJ0IHRoZSBkYXRhIGlzOgoKSW5zZXJ0IGludG8gdGFibGUg KCB3ZWJpbmFySWQsIHJlc3VsdCwgcmVnaXN0ZXJEYXRhICkKICAgICAgICAgICAgIHZhbHVlcygg OndlYmluYXJJZCwgOnJlc3VsdCwgOnJlcXVlc3QgKTsKCldoZXJlIHRoZSBjb2x1bW5zIGFyZSBh bGwgZGVmaW5lZCBhcyBwZXIgdGhlIHRhYmxlIGRlZmluaXRpb24gLSBleGNlcHQgdGhhdCDigJxy ZXN1bHTigJ0gaW4gdGhlIFJQRyBjb2RlIGlzIGFuIGluZGljYXRvci4gCgpUaGlzIGNvZGUgaGFz IGJlZW4gcnVubmluZyBmb3IgYSBjb3VwbGUgb2YgeWVhcnMgYnV0IHNpbmNlIG91ciBtb3ZlIHRv IDcuNiBoYXMgc3RhcnRlZCB0byBzb21ldGltZXMgdGhyb3cgU1FMQ09ERSAtNDA0IGFnYWluc3Qg dGhlIOKAnHJlc3VsdCIgY29sdW1uIGNsYWltaW5nIHRoYXQgaXRzIGxlbmd0aCBvZiA0IGV4Y2Vl ZHMgdGhlIGNhcGFjaXR5IG9mIHRoZSBjb2x1bW4uIEJ1dCBpdCBpc27igJl0IDQgbG9uZyBpdCBp cyAxLiBSdW5uaW5nIGluIGRlYnVnLCBJIGNhbiBzZWUgdGhhdCB0aGUgdGVtcCB2YXJpYWJsZSBm b3Ig4oCccmVzdWx04oCdIGNyZWF0ZWQgYnkgdGhlIHByZS1wcm9jZXNzb3IgaXMgY2hhcigxKS4g CgpOb3Qgc3VyZSB3aGVyZSBlbHNlIHRvIGxvb2suCgpJIGhhdmUgZ29vZ2xlZCBmb3IgUFRGcyBv ciByZXBvcnRlZCBlcnJvcnMgYnV0IGFtIG5vdCBzZWVpbmcgYW55dGhpbmcuCgpBbnlvbmUgZ290 IGFueSBpZGVhcyBvbiB3aGVyZSB0byBsb29rIG5leHQ/CgpJIGhhdmUgYSB3b3JrIGFyb3VuZCAt IGlmIEkgZmFjZSB0aGUgY2FzdCBvZiB0aGUgaW5kaWNhdG9yIHRvIGNoYXIoMSkgaXQgd29ya3Mu ICBHdWVzcyB0aGVyZSBpcyBhIGJ1ZyBpbiB0aGUgY29kZSBnZW5lcmF0ZWQgYnkgdGhlIHByZS1j b21waWxlci4KCkluc2VydCBpbnRvIHBhcnRuZXI0MDAvc3FscmVndGVzdCAoIHJlc3VsdCwgd2Vi aW5hcklkLCAgcmVnRGF0YSApCiAgICAgICAgICAgICB2YWx1ZXMoICBjYXN0ICg6cmVzdWx0IGFz IGNoYXIoMSkpLCA6d2ViaW5hcklkLCA6cmVxdWVzdCApOwoKCkpvbiBQYXJpcwoKLS0KVGhpcyBp cyB0aGUgUlBHIHByb2dyYW1taW5nIG9uIElCTSBpIChSUEc0MDAtTCkgbWFpbGluZyBsaXN0IFRv IHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20gVG8gc3Vi c2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKdmlzaXQ6IGh0dHBz Oi8vbGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vcnBnNDAwLWwKb3IgZW1haWw6 IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCkJlZm9yZSBwb3N0aW5nLCBwbGVh c2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVzIGF0IGh0dHBzOi8vYXJjaGl2 ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCgpQbGVhc2UgY29udGFjdCBzdXBwb3J0QHN1cHBvcnQu bWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgoKCi0t IApUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5n IGxpc3QKVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQRzQwMC1MQGxpc3RzLm1pZHJhbmdlLmNv bQpUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBjaGFuZ2UgbGlzdCBvcHRpb25zLAp2aXNp dDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbApv ciBlbWFpbDogUlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KQmVmb3JlIHBvc3Rp bmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmlldyB0aGUgYXJjaGl2ZXMKYXQgaHR0cHM6 Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0MDAtbC4KClBsZWFzZSBjb250YWN0IHN1cHBvcnRA c3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24gcmVsYXRlZCBxdWVzdGlv bnMuCgo=