Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Andy Cordell — — source: Informix-list mailing list archive (1991-1998)
Hello all,
What is the proper way to provide a SQL command line interface to
a user without making them create a sql command file to issue a
command? What I'd like is the ability to type something like
this on the unix command line:
<dbname> <SQL command here>
The response would come back to stdout.
This is the almost working script that I wrote:
#! /bin/sh
echo "$@" > temp.sql
dbaccess -e <dbname> temp.sql
The only problem with this is that it expands the * in
"select * from <table> " to be the current directory listing, so
I end up with :
select <insert really big directory listing here> from <table>
as my SQL command, which is not good.
Is this the right approach? Is there already a utility that will
provide SQL statements (not cmd files) from the command line?
Any help is much appreciated!
Andy Cordell
andy@bnr.ca
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.