Re: Re: SQL plus howto start a script

"Matt B." wrote:

> "Greg" <actiris_at_loxinfo.co.th> wrote in message
> news:39D0213C.C088D2CE_at_loxinfo.co.th...
> > I like to start that script from a client.
> > the script is located on the server in e:\server\localdir\my_script.sql
> >
> > so I try
> >
> > _at_my_script
> > sure he can't find it bec its on the server not on my local machine
>
> Right.
>
> > _at_e:\server\localdir\my_script
> > dosent work too, same reason.
> >
> > how to give the start command the information that the
> > given path is on the server not locally.
>
> I'm pretty sure the latter should work. Is your default file extension set to
> "sql" in your settings? Do a SHOW ALL and see if the default file extension
> for scripts is set to "sql" (usually is). If your server is UNIX, bear in mind
> that the file name might be case-sensitive too.
>
> -Matt

[Quoted] Thanks BUT

Working on NT Server, Workstation

SQL Parameter ist set to

sqlprompt "base1_LOGAP> "
sqlterminator ";" (hex 3b)
suffix "sql"

think about it
the SQL plus on my Worbox looks in to the local drives. Exept I set up a Network drive link in the settings of the start link from SQLplus
So there must be an additional keyword to point to the Server and look into e:\server\localdir\my_script

Greg Received on Wed Sep 27 2000 - 07:25:26 CEST