Re: SQL without licenced program product

[Dave Shaw <dshaw1@xxxxxxxxxxx>]

ASC's Sequel does not provide for embedded SQL in HLL's.  It DOES provide an
SQL-syntax replacement for OPNQRYF which is FANTASTIC, and there are lots of
other neat features that are much more difficult with any of IBM's SQL tools
and interfaces.  It slices, it dices, it even mices!  And the new version
now runs at security levels 40 and 50, so Al doesn't need to dismiss it out
of hand any more! <grin>

I am a very satisfied Sequel customer, and have been for 8 years.  ASC knows
my shop well, too - we're professionals at finding extreme ways to use and
abuse it.  In the end, it always works for us - they support it well.

Dave Shaw, General Nutrition, Greenville, SC (just down the road from BMW -
Bubba Makes Wheels :)
The opinions expressed may not be my employer's unless I'm sufficiently
persuasive...

-----Original Message-----
From: Buck Calabro <mcalabro@commsoft.net>
To: 'MIDRANGE-Lmidrangecom' <MIDRANGE-L@midrange.com>
Date: Monday, October 12, 1998 4:19 PM
Subject: RE: SQL without licenced program product


>On Monday, October 12, 1998 12:33 PM, Scott, Shadrach
>[SMTP:sscott@hiu.edu] wrote:
>>
>> I do not have the SQL development kit. But do I understand correctly
>> though
>> that I can use SQL with only the base OS? What can I do with out the
>> development kit? With it?
>
>With the licenced product you can embed SQL in your HLL programs.
>Without it, you can write any and all SQL statements via the use of a
>source file and STRQMQRY.  I've borrowed ideas from MC magazine (years
>ago) to write a command that lets me execute individual SQL statements
>from the command line.  It is invaluable to me when trying to do
>testing/debugging.
>
>A typical testing sequence might be:
>
>insert * into test/master (select * from production/master where
>aramt>100)
>insert * into test/invoice (select * from production/invoice where invmas
>in (select mastkey from test/master))
>
>This will load the records into the test system for customers whose A/R
>amount is over 100.  Very handy, because I can put these commands into a
>CL program, use variables and create or update a test environment very,
>very quickly.
>
>Advanced System Concepts (no affiliation) also have an SQL product, but I
>don't know if it lets you embed SQL into your HLL programs or not.
>
>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
>+---

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