RE: Embedded SQL in CL

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