• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: What database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: What database
      • From: MacFirst <email@hidden>
References: 
 >Re: What database (From: MacFirst <email@hidden>)

  • Prev by Date: Re: What database
  • Next by Date: Database Failover Questions
  • Previous by thread: Re: What database
  • Next by thread: Re: What database
  • Index(es):
    • Date
    • Thread