RE: SQL without licenced program product

[Buck Calabro <mcalabro@xxxxxxxxxxxx>]

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