Re: What database
Re: What database
- Subject: Re: What database
- From: MacFirst <email@hidden>
- Date: Thu, 21 Oct 2004 10:32:09 -0700
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." With this, I could
make an alias like:
alias mysql /Library/FrontBase/bin/sql92 mysql.sql
And mysql.sql would contain
connect to mydb user _MYUSER password 'my*passw0rd';
set commit FALSE;
As one example. Yes, I admit it's nit-pickery -- I'm just saying that it'd
be nice, is all. Extra-nice to have a handful of different aliases to mean
what I want. Also, I see that I can do the commit=false thing as -a --
missed that, first time around.
Also, you have a different vsn of the manual than I do. Mine only goes up
to p230, although the text to which you refer is on p181. Maybe I should go
check for new versions, eh? ;)
Thanks!
(Still waiting for someone to demonstrate that WOApplets -- bundled into the
.woa -- are possible... <G>)
_______________________________________________
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