Re: Weird SQL Problem
Daniel Gross <[email protected]> Sat, 2 May 2026 21:11:56 +0200
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
77u/V2VsbCAtIHllcyAtIGhpc3RvcmljYWxseSBhbiBpbmRpY2F0b3IgaXMgYSBDSEFSKDEpIGZp ZWxkLCB0aGF0IG9ubHkgY2FuIGJlICcwJyBvciAnMScgLSBJIHRoaW5rIHRoYXQgd2FzIG91ciB3 YXkgYmFjayBvbiBwdW5jaGVkIGNhcmRzIDstKSAtIHRvZGF5IEJPT0xFQU4gaXMgdGhlIHNhZmUg d2F5IHRvIGdvLiBBbmQgaW4gYW4gaWRlYWwgd29ybGQsIHRoZSBwcmUtY29tcGlsZXIgc2hvdWxk IGJlIGhlbHBmdWwgLSBidXQgd2UgbGl2ZSB3aXRoIGFuIGltcGVyZmVjdCBwcmUtY29tcGlsZXIg c2luY2UgaXQgZXhpc3RzLgoKQW5kIG5vdyB0aGF0IHlvdSBzYXkgaXQgLSB0aGUgcGhlbm9tZW5v biB3aXRoIHRoZSAiVCIgYXMgYSB2YWx1ZSBoYXMgb2NjdXJyZWQgdG8gbWUgdG9vIHNvbWUgdGlt ZSBhZ28gLSBidXQgSSBjYW4ndCByZW1lbWJlciB3aGF0IEkgaGF2ZSBkb25lIHRvIGN1cmUgaXQu IFByb2JhYmx5IEkgYWxzbyBDQVNUZWQgb3IgdXNlZCBhIENBU0UgZXhwcmVzc2lvbi4KClRoZSBl eHBsYW5hdGlvbiBmb3IgdGhhdCBwaGVub21lbm9uIHNlZW1zIHRvIHRoaXM6IGh0dHBzOi8vd3d3 LmlibS5jb20vZG9jcy9lbi9pLzcuNi4wP3RvcGljPXN0YXRlbWVudC1ib29sZWFuLWRhdGEtdHlw ZSAtIEkgcXVvdGUgZnJvbSB0aGUgcGFnZToKCj4gU3RyaW5nIHZhbHVlcyByZXByZXNlbnRpbmcg dHJ1ZSBhcmUgJ3QnICwgJ3RydWUnICwgJ3knLCAneWVzJyAsICdvbicsIGFuZCAnMScuIEZhbHNl IGNhbiBiZSByZXByZXNlbnRlZCBieSAnZicsICdmYWxzZScsICduJywgJ25vJywgJ29mZicsIGFu ZCAnMCcuIEFueSBjb21iaW5hdGlvbiBvZiB1cHBlcmNhc2UgYW5kIGxvd2VyY2FzZSBjaGFyYWN0 ZXJzIGFyZSByZWNvZ25pemVkLiAKClNvIC0gcHJvYmFibHkgdGhlIGluZGljYXRvciB2YWx1ZSAq T04gaXMgY29udmVydGVkIHRvICdUJyB3aGVuIHdyaXR0ZW4gdG8gdGhlIHRhYmxlIHdpdGggU1FM IC0gYmVjYXVzZSBzaW5jZSBCT09MRUFOIGV4aXN0cyBhcyBhIGRhdGEgdHlwZSwgaW5kaWNhdG9y cyBhcmUgdHJlYXRlZCBhcyBib29sZWFuIHZhbHVlcyBieSB0aGUgU1FMIGVuZ2luZS4gQnV0IHRo aXMgaXMgcHVyZSBzcGVjdWxhdGlvbiBvbiBteSBzaWRlLgoKQ2FuIHlvdSBsb29rIGludG8gdGhl IHRhYmxlIGRhdGE/IE1heWJlIGxvb2sgYXQgdGhlIHJvd3MsIHdoZXJlIHRoZSBTUUxSUEdMRSBm YWlscz8KClJlZ2FyZHMsCkRhbmllbAoKCgo+IEFtIDAyLjA1LjIwMjYgdW0gMjA6NDQgc2Nocmll YiBKb24gUGFyaXMgPGpvbi5wYXJpc0BwYXJ0bmVyNDAwLmNvbT46Cj4gCj4g77u/SSB1bmRlcnN0 YW5kIGFsbCB0aGF0IERhbmllbCBidXQgdGhlIHVuZGVybHlpbmcgZGF0YSB0eXBlIGZvciBhbiBS UEcgaW5kaWNhdG9yIGhhcyBhbHdheXMgYmVlbiBjaGFyKDEpLgo+IAo+IFBlcmhhcHMgbW9yZSB0 byB0aGUgcG9pbnQ6Cj4gCj4gMSkgaWYgdGhpcyB3YXMgYSBjb2RpbmcgZXJyb3Igb24gbXkgcGFy dCwgdGhlIHByZS1jb21waWxlciBzaG91bGQgc3BpdCBpdCBvdXQuIE5vdCBhY2NlcHQgaXQgYW5k IHNjcmV3IHVwIGF0IHJ1biB0aW1lLgo+IAo+IDIpIFRoaXMgaGFzIGJlZW4gd29ya2luZyBzaW5j ZSAyMDI0Cj4gCj4gMykgSWYgSSBtYW51YWxseSBjYXN0IHRoZSBpbmRpY2F0b3IgSSBubyBsb25n ZXIgZ2V0IGFuIGVycm9yIGJ1dCB0aGUgdmFsdWUgcmV0dXJuZWQgaXMgbm90IHplcm8gb3IgMS4g SXQgaXMgY3VycmVudGx5IGEg4oCcVOKAnSBmb3IgdGhlICpPbiBjb25kaXRpb24uCj4gCj4gNCkg VGhlIHRhYmxlIGhhcyBiZWVuIGFyb3VuZCBmb3Igc29tZSB0aW1lIGFuZCBhIGJ1bmNoIG9mIG90 aGVyIHN0dWZmIHdvdWxkIGhhdmUgdG8gY2hhbmdlIGlmIEkgc3dpdGNoIGl0IHRvIGJvb2xlYW4u IEnigJlkIHJhdGhlciBhdm9pZCB0aGF0Lgo+IAo+IExvb2tzIGxpa2UgSeKAmW0gZ29pbmcgdG8g aGF2ZSB0byDigJxtYW51YWxseeKAnSBpbnRlcnByZXQgdGhlIGluZGljYXRvciBhbmQgcGFzcyB0 aGUgcmVzdWx0aW5nIGNoYXIgZmllbGQgdG8gdGhlIFNRTC4KPiAKPiAKPiBKb24gUGFyaXMKPiAK PiAKPj4gT24gTWF5IDIsIDIwMjYsIGF0IDE0OjI3LCBEYW5pZWwgR3Jvc3MgPGRhbmllbEBxcGdt ci5kZT4gd3JvdGU6Cj4+IEhpIEpvbiwKPj4gaWYgeW91IHVzZSBhbiBpbmRpY2F0b3IgZm9yIHRo ZSBSRVNVTFQgY29sdW1uLCB0aGUgbmF0dXJhbCBTUUwgZGF0YSB0eXBlIHdvdWxkIGJlIEJPT0xF QU4uIEFuIGluZGljYXRvciBjYW4gb25seSBiZSAqT04gb3IgKk9GRiAtIGEgQm9vbGVhbiBjb2x1 bW4gY2FuIG9ubHkgYmUgVFJVRSAoKk9OKSBvciBGQUxTRSAoKk9GRikgLSBhbiBlbWJlZGRlZCBT UUwgaXMgY29ycmVjdGx5IGNhc3RpbmcvY29udmVydGluZyBiZXR3ZWVuIHRob3NlIDIgZGF0YSB0 eXBlcy4KPj4gSFRICj4+IERhbmllbAo+Pj4+IEFtIDAyLjA1LjIwMjYgdW0gMjA6MTUgc2Nocmll YiBKb24gUGFyaXMgPGpvbi5wYXJpc0BwYXJ0bmVyNDAwLmNvbT46Cj4+PiDvu79BcG9sb2dpZXMg aWYgdGhpcyBpcyBhIGR1cCBidXQgbXkgb3JpZ2luYWwgd2FzIHJlamVjdGVkIChJIHRoaW5rKSBh bmQgSSBjYW7igJl0IHNlZSBhbnl0aGluZyBmb3IgTWF5IGluIHRoZSBhcmNoaXZlcy4KPj4+IEkg aGF2ZSBhIHRhYmxlIGRlZmluZWQgYXM6Cj4+PiBSRUdJU1RFUlRJTUUgVElNRVNUQU1QIE5PVCBO VUxMIERFRkFVTFQgQ1VSUkVOVF9USU1FU1RBTVAsCj4+PiBXRUJJTkFSSUQgREVDSU1BTCgxMSwg MCkgTk9UIE5VTEwgREVGQVVMVCAwICwKPj4+IFJFU1VMVCBDSEFSKDEpIE5PVCBOVUxMIERFRkFV TFQgJzAnICwKPj4+IFJFR0lTVEVSREFUQSBWQVJDSEFSKDEwMDApIEFMTE9DQVRFKDMwMCkgQ0NT SUQgMzcgTk9UIE5VTEwKPj4+IFRoZSBTUUwgc3RhdGVtZW50IHRvIGluc2VydCB0aGUgZGF0YSBp czoKPj4+IEluc2VydCBpbnRvIHRhYmxlICggd2ViaW5hcklkLCByZXN1bHQsIHJlZ2lzdGVyRGF0 YSApCj4+PiAgICAgICAgICB2YWx1ZXMoIDp3ZWJpbmFySWQsIDpyZXN1bHQsIDpyZXF1ZXN0ICk7 Cj4+PiBXaGVyZSB0aGUgY29sdW1ucyBhcmUgYWxsIGRlZmluZWQgYXMgcGVyIHRoZSB0YWJsZSBk ZWZpbml0aW9uIC0gZXhjZXB0IHRoYXQg4oCccmVzdWx04oCdIGluIHRoZSBSUEcgY29kZSBpcyBh biBpbmRpY2F0b3IuCj4+PiBUaGlzIGNvZGUgaGFzIGJlZW4gcnVubmluZyBmb3IgYSBjb3VwbGUg b2YgeWVhcnMgYnV0IHNpbmNlIG91ciBtb3ZlIHRvIDcuNiBoYXMgc3RhcnRlZCB0byBzb21ldGlt ZXMgdGhyb3cgU1FMQ09ERSAtNDA0IGFnYWluc3QgdGhlIOKAnHJlc3VsdCIgY29sdW1uIGNsYWlt aW5nIHRoYXQgaXRzIGxlbmd0aCBvZiA0IGV4Y2VlZHMgdGhlIGNhcGFjaXR5IG9mIHRoZSBjb2x1 bW4uIEJ1dCBpdCBpc27igJl0IDQgbG9uZyBpdCBpcyAxLiBSdW5uaW5nIGluIGRlYnVnLCBJIGNh biBzZWUgdGhhdCB0aGUgdGVtcCB2YXJpYWJsZSBmb3Ig4oCccmVzdWx04oCdIGNyZWF0ZWQgYnkg dGhlIHByZS1wcm9jZXNzb3IgaXMgY2hhcigxKS4KPj4+IE5vdCBzdXJlIHdoZXJlIGVsc2UgdG8g bG9vay4KPj4+IEkgaGF2ZSBnb29nbGVkIGZvciBQVEZzIG9yIHJlcG9ydGVkIGVycm9ycyBidXQg YW0gbm90IHNlZWluZyBhbnl0aGluZy4KPj4+IEFueW9uZSBnb3QgYW55IGlkZWFzIG9uIHdoZXJl IHRvIGxvb2sgbmV4dD8KPj4+IEkgaGF2ZSBhIHdvcmsgYXJvdW5kIC0gaWYgSSBmYWNlIHRoZSBj YXN0IG9mIHRoZSBpbmRpY2F0b3IgdG8gY2hhcigxKSBpdCB3b3Jrcy4gIEd1ZXNzIHRoZXJlIGlz IGEgYnVnIGluIHRoZSBjb2RlIGdlbmVyYXRlZCBieSB0aGUgcHJlLWNvbXBpbGVyLgo+Pj4gSW5z ZXJ0IGludG8gcGFydG5lcjQwMC9zcWxyZWd0ZXN0ICggcmVzdWx0LCB3ZWJpbmFySWQsICByZWdE YXRhICkKPj4+ICAgICAgICAgIHZhbHVlcyggIGNhc3QgKDpyZXN1bHQgYXMgY2hhcigxKSksIDp3 ZWJpbmFySWQsIDpyZXF1ZXN0ICk7Cj4+PiBKb24gUGFyaXMKPj4+IC0tCj4+PiBUaGlzIGlzIHRo ZSBSUEcgcHJvZ3JhbW1pbmcgb24gSUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5nIGxpc3QKPj4+IFRv IHBvc3QgYSBtZXNzYWdlIGVtYWlsOiBSUEc0MDAtTEBsaXN0cy5taWRyYW5nZS5jb20KPj4+IFRv IHN1YnNjcmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCj4+PiB2aXNp dDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFpbG1hbi9saXN0aW5mby9ycGc0MDAtbAo+ Pj4gb3IgZW1haWw6IFJQRzQwMC1MLXJlcXVlc3RAbGlzdHMubWlkcmFuZ2UuY29tCj4+PiBCZWZv cmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwo+ Pj4gYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0MDAtbC4KPj4+IFBsZWFzZSBj b250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJzY3JpcHRpb24g cmVsYXRlZCBxdWVzdGlvbnMuCj4+IC0tCj4+IFRoaXMgaXMgdGhlIFJQRyBwcm9ncmFtbWluZyBv biBJQk0gaSAoUlBHNDAwLUwpIG1haWxpbmcgbGlzdAo+PiBUbyBwb3N0IGEgbWVzc2FnZSBlbWFp bDogUlBHNDAwLUxAbGlzdHMubWlkcmFuZ2UuY29tCj4+IFRvIHN1YnNjcmliZSwgdW5zdWJzY3Jp YmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMsCj4+IHZpc2l0OiBodHRwczovL2xpc3RzLm1pZHJh bmdlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3JwZzQwMC1sCj4+IG9yIGVtYWlsOiBSUEc0MDAtTC1y ZXF1ZXN0QGxpc3RzLm1pZHJhbmdlLmNvbQo+PiBCZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2Ug YSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZlcwo+PiBhdCBodHRwczovL2FyY2hpdmUubWlk cmFuZ2UuY29tL3JwZzQwMC1sLgo+PiBQbGVhc2UgY29udGFjdCBzdXBwb3J0QHN1cHBvcnQubWlk cmFuZ2UuY29tIGZvciBhbnkgc3Vic2NyaXB0aW9uIHJlbGF0ZWQgcXVlc3Rpb25zLgo+IAo+IC0t Cj4gVGhpcyBpcyB0aGUgUlBHIHByb2dyYW1taW5nIG9uIElCTSBpIChSUEc0MDAtTCkgbWFpbGlu ZyBsaXN0Cj4gVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQRzQwMC1MQGxpc3RzLm1pZHJhbmdl LmNvbQo+IFRvIHN1YnNjcmliZSwgdW5zdWJzY3JpYmUsIG9yIGNoYW5nZSBsaXN0IG9wdGlvbnMs Cj4gdmlzaXQ6IGh0dHBzOi8vbGlzdHMubWlkcmFuZ2UuY29tL21haWxtYW4vbGlzdGluZm8vcnBn NDAwLWwKPiBvciBlbWFpbDogUlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5taWRyYW5nZS5jb20KPiBC ZWZvcmUgcG9zdGluZywgcGxlYXNlIHRha2UgYSBtb21lbnQgdG8gcmV2aWV3IHRoZSBhcmNoaXZl cwo+IGF0IGh0dHBzOi8vYXJjaGl2ZS5taWRyYW5nZS5jb20vcnBnNDAwLWwuCj4gCj4gUGxlYXNl IGNvbnRhY3Qgc3VwcG9ydEBzdXBwb3J0Lm1pZHJhbmdlLmNvbSBmb3IgYW55IHN1YnNjcmlwdGlv biByZWxhdGVkIHF1ZXN0aW9ucy4KCi0tIApUaGlzIGlzIHRoZSBSUEcgcHJvZ3JhbW1pbmcgb24g SUJNIGkgKFJQRzQwMC1MKSBtYWlsaW5nIGxpc3QKVG8gcG9zdCBhIG1lc3NhZ2UgZW1haWw6IFJQ RzQwMC1MQGxpc3RzLm1pZHJhbmdlLmNvbQpUbyBzdWJzY3JpYmUsIHVuc3Vic2NyaWJlLCBvciBj aGFuZ2UgbGlzdCBvcHRpb25zLAp2aXNpdDogaHR0cHM6Ly9saXN0cy5taWRyYW5nZS5jb20vbWFp bG1hbi9saXN0aW5mby9ycGc0MDAtbApvciBlbWFpbDogUlBHNDAwLUwtcmVxdWVzdEBsaXN0cy5t aWRyYW5nZS5jb20KQmVmb3JlIHBvc3RpbmcsIHBsZWFzZSB0YWtlIGEgbW9tZW50IHRvIHJldmll dyB0aGUgYXJjaGl2ZXMKYXQgaHR0cHM6Ly9hcmNoaXZlLm1pZHJhbmdlLmNvbS9ycGc0MDAtbC4K ClBsZWFzZSBjb250YWN0IHN1cHBvcnRAc3VwcG9ydC5taWRyYW5nZS5jb20gZm9yIGFueSBzdWJz Y3JpcHRpb24gcmVsYXRlZCBxdWVzdGlvbnMuCgo=