Re: Non-compiled SQL Scripts?
>From: "Joshua D. Molaver" <jdm5@voicenet.com>
>Date: Thu, 17 Apr 1997 11:11:25 -0400
>X-Informix-List-Id: <news.36744>
>
>I have just begun working with Informix Online v.5 under SCO, and am
>seeking some advice.
>
>I have been investigating the 4GL and ESQL/C packages. I want to send a
>series of SQL statements (inserts, updates, and deletes) to a server and
>have them executed as a transaction.
Various people have suggested DB-Access or ISQL.
>I also need to be able to detect and respond to an error condition.
This rules out DB-Access and ISQL.
>It appears that 4GL and ESQL/C are both compiled languages.
They are.
>I need to able to send the SQL statements as text files and have them
>executed (via something like dbaccess or isql, from the command line)
>without any compilation procedures. Is this possible?
Yes, of course. But not necessarily as standard! Do you have ESQL/C
on your machine? If so, then I'd suggest that you investigate one of
two avenues.
If you use Perl 5, then try using DBI and DBD::Informix. I've attached
some notes about where to get that from.
If you don't use Perl, then maybe you should try SQLCMD. Version 8 is
available from the IIUG archives, at http://www.iiug.org. However, I've
also attached a shell archive of Version 23 (this should go into the IIUG
archives -- please!). There's a README file which discusses what you need
to do to compile and install the software.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>
===========================================================================
Where is DBD::Informix
======================
The site http://www.hermetica.com/technologia/DBI does not necessarily
contain pointers to the latest version of DBD::Informix.
The latest version of DBD::Informix should be available by accessing:
http://www.perl.org/CPAN/modules/by-module/07_Database_Interfaces
There are two sub-directories: DBI for the latest version of DBI, and DBD
for the latest version of DBD::Informix and all the other DBD modules.
In case of doubt, I use the FTP site:
ftp://wcarchive.cdrom.com/perl/CPAN/modules/by-module/DBD
This is based in Walnut Creek, near San Francisco, CA, USA. There may well
be another CPAN mirror site closer to you -- check in the web pages for The
Perl Institute (http://www.perl.org). Note that CPAN (Comprehensive Perl
Archive Network) automatically multiplexes your download requests to a
mirror site near you.
Last updated: 1997-03-18 for DBD::Informix Version 0.53
===========================================================================
: "@(#)shar.sh 1.9"
#! /bin/sh
#
# This is a shell archive.
# Remove everything above this line and run sh on the resulting file.
# If this archive is complete, you will see this message at the end:
# "All files extracted"
#
# Created: Thu Apr 17 17:00:56 PDT 1997 by johnl at Informix Software Ltd.
# Files archived in this archive:
# Depend.mk
# Install.mk
# Makefile
# README
# TODO
# chkfifo.c
# cistrcmp.c
# cistrstr.c
# config.h
# context.c
# context.h
# datefmt.c
# debug.h
# decsci.c
# decsci.h
# describe.ec
# describe.h
# dumpblob.ec
# dumpdec.ec
# dumpdtime.ec
# dumpintvl.ec
# dumpsqlca.ec
# dumpsqlda.ec
# dumpvalue.ec
# efopen.c
# emalloc.c
# emalloc.h
# esql.sh
# esql4_00.h
# esql4_10.h
# esql5_00.h
# esqlc.h
# esqlc.mk
# esqllib.h
# esqlutil.h
# fcopy.c
# getopt.c
# getopt.h
# histdump.c
# history.c
# history.h
# instfile.sh
# internal.c
# internal.h
# jlss.sh
# jtypes.c
# ldblob.ec
# main.c
# memmove.c
# memory.c
# memory.h
# mkbod.sh
# mkindent.sh
# mkpath.sh
# mkversion.sh
# newserver.sh
# output.c
# output.h
# readcmd.c
# reload.ec
# sqlcfg.h
# sqlclean.1
# sqlclean.sh
# sqlclient.sh
# sqlcmd.1
# sqlcmd.bod
# sqlcmd.ec
# sqlcmd.h
# sqlcmd.ins
# sqlcmd.lst
# sqlerr.c
# sqlerr.h
# sqlproto.h
# sqlserver.sh
# sqltype.ec
# stderr.c
# stderr.h
# strdup.c
# timer.c
# timer.h
# updblob.ec
# vstrcpy.c
#
#--------------------
if [ -f Depend.mk -a "$1" != "-c" ]
then echo shar: Depend.mk already exists
else
echo 'x - Depend.mk (2995 characters)'
sed -e 's/^X//' >Depend.mk <<'SHAR-EOF'
X# @(#)Depend.mk 1.10 93/05/16
X#
X# @(#)SQLCMD Version 23 (1997-04-17)
X#
X# Include file dependencies for SQLCMD/SQLUNLOAD/SQLRELOAD
X
XINC1 = .
X
X#emalloc.h: ${INC1}/config.h
X#esqlc.h: ${INC1}/esql4_00.h
X#esqlc.h: ${INC1}/esql4_10.h
X#esqlc.h: ${INC1}/esql5_00.h
X#esqlc.h: ${INC1}/esqllib.h
X#output.h: ${INC1}/esqlc.h
X#sqlcfg.h: ${INC1}/config.h
X
Xcontext.o: ${INC1}/context.h
Xcontext.o: ${INC1}/emalloc.h
Xcontext.o: ${INC1}/history.h
Xcontext.o: ${INC1}/sqlcfg.h
Xcontext.o: ${INC1}/sqlcmd.h
Xcontext.o: ${INC1}/sqlerr.h
Xcontext.o: ${INC1}/sqlproto.h
Xcontext.o: ${INC1}/stderr.h
X
Xdecsci.o: ${INC1}/esqlc.h
X
Xdescribe.o: ${INC1}/emalloc.h
Xdescribe.o: ${INC1}/esqlc.h
Xdescribe.o: ${INC1}/stderr.h
X
Xefopen.o: ${INC1}/sqlerr.h
Xefopen.o: ${INC1}/sqlproto.h
X
Xemalloc.o: ${INC1}/config.h
Xemalloc.o: ${INC1}/debug.h
Xemalloc.o: ${INC1}/emalloc.h
Xemalloc.o: ${INC1}/stderr.h
X
Xfcopy.o: ${INC1}/stderr.h
X
Xhistdump.o: ${INC1}/emalloc.h
Xhistdump.o: ${INC1}/getopt.h
Xhistdump.o: ${INC1}/history.h
Xhistdump.o: ${INC1}/sqlcfg.h
Xhistdump.o: ${INC1}/stderr.h
X
Xhistory.o: ${INC1}/emalloc.h
Xhistory.o: ${INC1}/history.h
Xhistory.o: ${INC1}/sqlcfg.h
Xhistory.o: ${INC1}/sqlcmd.h
Xhistory.o: ${INC1}/sqlproto.h
Xhistory.o: ${INC1}/stderr.h
X
Xinternal.o: ${INC1}/context.h
Xinternal.o: ${INC1}/esqlc.h
Xinternal.o: ${INC1}/history.h
Xinternal.o: ${INC1}/internal.h
Xinternal.o: ${INC1}/sqlcfg.h
Xinternal.o: ${INC1}/sqlcmd.h
Xinternal.o: ${INC1}/sqlerr.h
Xinternal.o: ${INC1}/sqlproto.h
Xinternal.o: ${INC1}/stderr.h
Xinternal.o: ${INC1}/timer.h
X
Xmain.o: ${INC1}/context.h
Xmain.o: ${INC1}/emalloc.h
Xmain.o: ${INC1}/esqlc.h
Xmain.o: ${INC1}/getopt.h
Xmain.o: ${INC1}/history.h
Xmain.o: ${INC1}/internal.h
Xmain.o: ${INC1}/output.h
Xmain.o: ${INC1}/sqlcfg.h
Xmain.o: ${INC1}/sqlcmd.h
Xmain.o: ${INC1}/sqlerr.h
Xmain.o: ${INC1}/sqlproto.h
Xmain.o: ${INC1}/stderr.h
X
Xmemory.o: ${INC1}/emalloc.h
Xmemory.o: ${INC1}/memory.h
Xmemory.o: ${INC1}/sqlerr.h
X
Xoutput.o: ${INC1}/context.h
Xoutput.o: ${INC1}/emalloc.h
Xoutput.o: ${INC1}/esqlc.h
Xoutput.o: ${INC1}/output.h
Xoutput.o: ${INC1}/sqlcfg.h
Xoutput.o: ${INC1}/sqlcmd.h
Xoutput.o: ${INC1}/sqlerr.h
Xoutput.o: ${INC1}/sqlproto.h
X
Xreadcmd.o: ${INC1}/sqlproto.h
Xreadcmd.o: ${INC1}/stderr.h
X
Xreload.o: ${INC1}/context.h
Xreload.o: ${INC1}/describe.h
Xreload.o: ${INC1}/emalloc.h
Xreload.o: ${INC1}/esqlc.h
Xreload.o: ${INC1}/memory.h@@NL