Subject Re: [ib-support] executing SQL scripts on linux clients.
Author sibusiso xolo
Helen Borrie wrote:
> Have you thought about downloading the manuals instead of guessing? The
> isql documentation is in the Operations Guide.

Helen:

Thanks for the suggestion but weeks ago I had in fact downloaded the
60All.zip documentation and unzipped then in my home directory. The client
machine I used has SuSE8 installed. I tried loading one of the resulting
pdf file in the Konqueror postscript viewer and it did not load. So I gave
up.

After your suggestion I tied loading in adobe acrobat and it loaded. I then
tried with Ghostview postscript viewer and it loaded. I then tried another
machine running redhat7.3 and surprise suprise the pdf file from the
60All.zip loaded in konqueror.. Curiouslly redhat is not supposed to
support Konqueror as well as SuSE!

After checking the pdf files, the one which I most missed is the language
reference. So again thanks for your suggestion.

regards
sibu
On Monday 02 September 2002 02:18, Helen Borrie wrote:
> At 06:45 PM 01-09-02 +0000, you wrote:
> >Greetings,
> >
> >I would like to know the procedure for executing SQL scripts in isql. I am
> >using linux.
> >
> >I can envisage a way to use the edit command from isql to open an editor
> >(such as vi) then load the prepared sql file then save it (it goes in
> >/tmp) and on quitting the script will execute.
> >
> >However what I would like to know IS if there is another way using Load
> >Script or Execute Script (as with IBConsole) from the isql comand prompt?
>
> No. IBConsole uses components built over the Services API which itself
> does internal macro calls to isql.
>
> Direct from the command-line do
>
> /opt/interbase/bin/isql -input /data/scripts/myscript.sql
>
> The interactive isql interface is more friendly for writing and running
> scripts. Inside isql you would do
>
> SQL> input /data/scripts/myscript.sql
> Make sure there is a carriage return following the last line of the script.
>
> Have you thought about downloading the manuals instead of guessing? The
> isql documentation is in the Operations Guide.
>
> heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/