|
Roger, To a degree I agree with your solution, there are others solutions (as many as solution providers!), but correct me if I'm wrong, the original request was a CL solution without calling any other programs. 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. That's where I second your suggestion. 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. But then again, I'm a subscriber of modularity and not monolithic ;-) Happy holidays, James W. Kilgore email@James-W-Kilgore.com Roger Boucher wrote: > You may want to try a QMQRY. Look into the commands CRTQMQRY and > STRQMQRY. The will allow you to create an SQL statement in a source > member and compile it into an executable object which can be run from a > CL program. Hope this helps in your situation. > > -----Original Message----- > From: David Gibbs [mailto:david@midrange.com] > Sent: Thursday, December 17, 1998 5:03 PM > To: MIDRANGE-L@midrange.com > Subject: Re: Embedded SQL in CL > > At 01:43 PM 12/17/98 , Gary Lehman wrote: > >I know this has been asked before, but how does one embed SQL in a CL > >program. I use SQL all the time in my COBOL programs, but have never > >attempted it in CL. > > That question has a very easy answer ... you don't. > > SQL can only be embeded in a HLL that has the appropriate > pre-processor... > RPG, C, COBOL, etc, all have one... CL does not. > > There are ways to execute a SQL statement in a CL ... but it's not the > same. > > I know that ASC's Sequel product has a OPNSQLF (or something to that > effect) that is similar to OPNQRYF, but uses a SQL statement. > > david > > -- > | Internet: david@midrange.com > | WWW: http://www.midrange.com/david > | > | ... A man can move mountains, a world can be turned, > | and the greatest of distances easily spanned, > | When the strength that's invested in making a fist > | is transformed into shaking a hand > | > | - DMRoth > > +--- > | 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 > +--- > +--- > | 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 > +--- +--- | 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.