RE: Killing of SQL users (and useful link to SQL Syntax Guide)

["George Sagen" <gsagen@xxxxxxxxxxxxxxxxxxx>]

Many of them suffer natural and immediate heart-attack deaths as a result of
their careless update queries. A Darwinian example of natural selection in
the IT world.

A good place for AUTHORIZED users of SQL to look up SQL syntax for the
AS/400 is:
http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/db2/rbafzmst0
2.htm#ToC

A safer way to let end users who like SQL to create queries is to give them
MSAccess, and setup their ODBC DSN to read-only mode. Another advantage to
using MSAccess over command line SQL is the easy portability of the SQL
results table into spreadsheets and other wonderful end-user toys.

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com 

PrimeSource Technologies, L.L.C.
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of
.  mgross@gbc.com
.  Sent: Tuesday, July 20, 1999 2:10 PM
.  To: BPCS-L@midrange.com
.  Subject: Re[2]: Performance & SQL coding
.
.
.  The end-users creating queries should be killed!
.
.  +---
.  | This is the BPCS Users Mailing List!
.  | To submit a new message, send your mail to BPCS-L@midrange.com.
.  | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
.  | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
.  | Questions should be directed to the list owner: dasmussen@aol.com
.  +---
.

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---