Re: Embedded SQL in CL

[email@xxxxxxxxxxxxxxxxxxx (James W Kilgore)]

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
+---