|
>Now if the shop has no other options than CL, one could build >a "black box" to create the QRYSLT string or MAPFLD string then >*CAT the results to pass to QCMDEXC and have dynamic execution. >But you still wind up with a called program. QMQRY comes with OS400, so even shops without HLL compilers can use this "solution." In fact, David has posted the source for a CL command that takes an entire SQL statement as input and runs it via QMQRY - essentially SQL in a CL program. Someone else posted similar code right to the list; a generic CL command interface into QMQRY. Having said that, it is NOT like embedding SQL in a HLL program, where one can do a FETCH INTO, etc. You can do any SQL statement that doesn't involve host variables via QMQRY which includes things like INSERT INTO, DELETE FROM, UPDATE, CREATE TABLE, DROP TABLE, etc. But this is a restriction in CL - CL can do Input operations via RCVF, but it can't do output. All in all, I think that most of us agree with James when he says that "We've tried similar situations and have decided that calling a "better" language then CL, that was easier to read and understand. which would build the request was IMHO a "cleaner" solution." - CL has its strengths, but I/O is not one of them! Buck Calabro CommSoft, Albany, NY mailto:mcalabro@commsoft.net +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
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.