Re: Weird SQL Problem
Daniel Gross <[email protected]> Sat, 2 May 2026 20:27:40 +0200
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
SGkgSm9uLAoKaWYgeW91IHVzZSBhbiBpbmRpY2F0b3IgZm9yIHRoZSBSRVNVTFQgY29sdW1uLCB0 aGUgbmF0dXJhbCBTUUwgZGF0YSB0eXBlIHdvdWxkIGJlIEJPT0xFQU4uIEFuIGluZGljYXRvciBj YW4gb25seSBiZSAqT04gb3IgKk9GRiAtIGEgQm9vbGVhbiBjb2x1bW4gY2FuIG9ubHkgYmUgVFJV RSAoKk9OKSBvciBGQUxTRSAoKk9GRikgLSBhbiBlbWJlZGRlZCBTUUwgaXMgY29ycmVjdGx5IGNh c3RpbmcvY29udmVydGluZyBiZXR3ZWVuIHRob3NlIDIgZGF0YSB0eXBlcy4gCgpIVEgKRGFuaWVs CgoKPiBBbSAwMi4wNS4yMDI2IHVtIDIwOjE1IHNjaHJpZWIgSm9uIFBhcmlzIDxqb24ucGFyaXNA cGFydG5lcjQwMC5jb20+Ogo+IAo+IO+7v0Fwb2xvZ2llcyBpZiB0aGlzIGlzIGEgZHVwIGJ1dCBt eSBvcmlnaW5hbCB3YXMgcmVqZWN0ZWQgKEkgdGhpbmspIGFuZCBJIGNhbuKAmXQgc2VlIGFueXRo aW5nIGZvciBNYXkgaW4gdGhlIGFyY2hpdmVzLgo+IAo+IEkgaGF2ZSBhIHRhYmxlIGRlZmluZWQg YXM6Cj4gCj4gUkVHSVNURVJUSU1FIFRJTUVTVEFNUCBOT1QgTlVMTCBERUZBVUxUIENVUlJFTlRf VElNRVNUQU1QLAo+IFdFQklOQVJJRCBERUNJTUFMKDExLCAwKSBOT1QgTlVMTCBERUZBVUxUIDAg LAo+IFJFU1VMVCBDSEFSKDEpIE5PVCBOVUxMIERFRkFVTFQgJzAnICwKPiBSRUdJU1RFUkRBVEEg VkFSQ0hBUigxMDAwKSBBTExPQ0FURSgzMDApIENDU0lEIDM3IE5PVCBOVUxMCj4gCj4gVGhlIFNR TCBzdGF0ZW1lbnQgdG8gaW5zZXJ0IHRoZSBkYXRhIGlzOgo+IAo+IEluc2VydCBpbnRvIHRhYmxl ICggd2ViaW5hcklkLCByZXN1bHQsIHJlZ2lzdGVyRGF0YSApCj4gICAgICAgICAgICAgdmFsdWVz KCA6d2ViaW5hcklkLCA6cmVzdWx0LCA6cmVxdWVzdCApOwo+IAo+IFdoZXJlIHRoZSBjb2x1bW5z IGFyZSBhbGwgZGVmaW5lZCBhcyBwZXIgdGhlIHRhYmxlIGRlZmluaXRpb24gLSBleGNlcHQgdGhh dCDigJxyZXN1bHTigJ0gaW4gdGhlIFJQRyBjb2RlIGlzIGFuIGluZGljYXRvci4KPiAKPiBUaGlz IGNvZGUgaGFzIGJlZW4gcnVubmluZyBmb3IgYSBjb3VwbGUgb2YgeWVhcnMgYnV0IHNpbmNlIG91 ciBtb3ZlIHRvIDcuNiBoYXMgc3RhcnRlZCB0byBzb21ldGltZXMgdGhyb3cgU1FMQ09ERSAtNDA0 IGFnYWluc3QgdGhlIOKAnHJlc3VsdCIgY29sdW1uIGNsYWltaW5nIHRoYXQgaXRzIGxlbmd0aCBv ZiA0IGV4Y2VlZHMgdGhlIGNhcGFjaXR5IG9mIHRoZSBjb2x1bW4uIEJ1dCBpdCBpc27igJl0IDQg bG9uZyBpdCBpcyAxLiBSdW5uaW5nIGluIGRlYnVnLCBJIGNhbiBzZWUgdGhhdCB0aGUgdGVtcCB2 YXJpYWJsZSBmb3Ig4oCccmVzdWx04oCdIGNyZWF0ZWQgYnkgdGhlIHByZS1wcm9jZXNzb3IgaXMg Y2hhcigxKS4KPiAKPiBOb3Qgc3VyZSB3aGVyZSBlbHNlIHRvIGxvb2suCj4gCj4gSSBoYXZlIGdv b2dsZWQgZm9yIFBURnMgb3IgcmVwb3J0ZWQgZXJyb3JzIGJ1dCBhbSBub3Qgc2VlaW5nIGFueXRo aW5nLgo+IAo+IEFueW9uZSBnb3QgYW55IGlkZWFzIG9uIHdoZXJlIHRvIGxvb2sgbmV4dD8KPiAK PiBJIGhhdmUgYSB3b3JrIGFyb3VuZCAtIGlmIEkgZmFjZSB0aGUgY2FzdCBvZiB0aGUgaW5kaWNh dG9yIHRvIGNoYXIoMSkgaXQgd29ya3MuICBHdWVzcyB0aGVyZSBpcyBhIGJ1ZyBpbiB0aGUgY29k ZSBnZW5lcmF0ZWQgYnkgdGhlIHByZS1jb21waWxlci4KPiAKPiBJbnNlcnQgaW50byBwYXJ0bmVy NDAwL3NxbHJlZ3Rlc3QgKCByZXN1bHQsIHdlYmluYXJJZCwgIHJlZ0RhdGEgKQo+ICAgICAgICAg ICAgIHZhbHVlcyggIGNhc3QgKDpyZXN1bHQgYXMgY2hhcigxKSksIDp3ZWJpbmFySWQsIDpyZXF1 ZXN0ICk7Cj4gCj4gCj4gSm9uIFBhcmlzCj4gCj4gLS0KPiBUaGlzIGlzIHRoZSBSUEcgcHJvZ3Jh bW1pbmcgb24gSUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5nIGxpc3QKPiBUbyBwb3N0IGEgbWVzc2Fn ZSBlbWFpbDogUlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4gVG8gc3Vic2NyaWJlLCB1bnN1 YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKPiB2aXNpdDogaHR0cHM6Ly9saXN0cy5t aWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbAo+IG9yIGVtYWlsOiBSUEc0MDAt TC1yZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQo+IEJlZm9yZSBwb3N0aW5nLCBwbGVhc2UgdGFr ZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVzCj4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1p ZHJhbmdlLmNvbS9ycGc0MDAtbC4KPiAKPiBQbGVhc2UgY29udGFjdCBzdXBwb3J0QHN1cHBvcnQu bWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgo+IAot LSAKVGhpcyBpcyB0aGUgUlBHIHByb2dyYW1taW5nIG9uIElCTSBpIChSUEc0MDAtTCkgbWFpbGlu ZyBsaXN0ClRvIHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5j b20KVG8gc3Vic2NyaWJlLCB1bnN1YnNjcmliZSwgb3IgY2hhbmdlIGxpc3Qgb3B0aW9ucywKdmlz aXQ6IGh0dHBzOi8vbGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vcnBnNDAwLWwK b3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCkJlZm9yZSBwb3N0 aW5nLCBwbGVhc2UgdGFrZSBhIG1vbWVudCB0byByZXZpZXcgdGhlIGFyY2hpdmVzCmF0IGh0dHBz Oi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCgpQbGVhc2UgY29udGFjdCBzdXBwb3J0 QHN1cHBvcnQubWlkcmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rp b25zLgoK