× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Embedded SQL in CL
  • From: email@xxxxxxxxxxxxxxxxxxx (James W Kilgore)
  • Date: Fri, 18 Dec 1998 21:59:44 -0800
  • Organization: Progressive Data Systems, Inc.

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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.