Re: How to execute a SQL command from the <SRVMGRL> prompt on a UNIX system

Henrik Meldgaard Frisk wrote:
>
> Hi All
>
> I am working on a 'CREATE DATABASE' project on a HP-UX system, and I want to
> execute some commands from the Server Manager program prompt (svrmgrl)
> It is a SQL command that exists of several lines.
>
> My prompt looks like this:
>
> SVRMGR> (Here I have my SQL commands
> 2> (.........etc.
> 3> (.........etc.
> 4> (.........end) AND THEN WHAT !!
>
> How do I execute my SQL commands that fills 4 lines ? There must be some way
> to end the command and execute it.
> A keyboard combination or a sign. I can't find it. I just get a new line all
> the time.
>
> Can enyone help me?
>
> Henrik
> Denmark

do it as a here-document and include the connect statement in the commands:

svrmgrl <<-sqlEOF
connect system/manager
select *
from mytable
where something = mycondition;
exit;
sqlEOF Received on Tue Dec 07 1999 - 11:56:10 CST