Re: What database
Re: What database
- Subject: Re: What database
- From: Geert Clemmensen <email@hidden>
- Date: Thu, 21 Oct 2004 19:44:42 +0200
On Oct 21, 2004, at 7:32 PM, MacFirst wrote:
on 10/21/04 10:17 AM, Hugi Thordarson <email@hidden> went on and on
saying, in part:
* I wish I knew a way to launch their sql92 tool with a script, so
that I
could alias shortcuts to launch the tool and immediately connect to
this or
that db.
Hmmm, how about:
./sql92 SomeScriptFile.sql
For further info, check out p252 in the FB user manual:
"sql92 <options> [<filename>]
If a filename is specified, sql92 reads and executes the SQL 92
statements stored in the named file. If the input file is omitted, SQL
92 statements are read from standard input. All output is written to
standard output."
Ok, since you're the second person to mock my aversion to documentation
(blasphemers! ;), I'll clarify...
What REALLY happens is: if a filename is specified, SQL92 reads &
executes
the statements stored in the named file, THEN QUITS.
What I'd LIKE is: a way to say "run sql92, execute the commands in my
script
to start up, then leave me at the sql92 command prompt."
This is actually already possible, albeit not documented. Create a file
called .sql92rc.sql with the commands you want executed when sql92 is
launched. The search path is current directory followed by the home
directory of the user launching sql92.
Regards,
Geert B. Clemmensen
www.frontbase.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden