|
My fellow geeks:Suppose I need to dump the results of several SQL SELECTs into a uniquely keyed file. And since I'm endeavoring to logically OR everything together, I don't give a rodent's defecatory orifice about key collisions, other than wanting them ignored, as quietly as possible.
SQL for Dummies mentions something about a MERGE statement, without going into a lot of detail, and it sounds tailor-made for the problem at hand, but I don't see anything about any such thing in the V4R2 or V4R4 docs (V4R2 being my usual reference, since it's the last pre-InfoCenter reference, and V4R4 being the minimum platform for the product).
On a related note, suppose I need to logically AND a result set with a file, under similar circumstances. Or logically AND NOT a result set with a file, again under similar circumstances.
At any rate, everything would be executed under CLI. Can anybody point me in the right direction? -- JHHL
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
