| Author |
New Sybase User Question
|
|
|
| I am trying to create a sql script to run on our Sybase 12.6
server. The OS of the server is Red Hat Linux 3.0. I
created a simple script using notepad with the following
stored procedure in it.
sp_iqlistlockedusers
; OUTPUT TO Jays_locked_accounts
.xls
FORMAT EXCEL;
I saved this file as (filename).sql. I placed this file on
the Sybase server in the /home/sybase directory. The
problem is I am not sure how to execute this script. Can
someone please enlighten me? I am brand new to Sybase so
please forgive me if this is a stupid request.
Thanks.
| |
|
| basically you want to create a shell script that executes
dbisql that then executes your file...
create a shell script to execute something similiar to this:
dbisql -c
" uid=your_id;pwd=your
_pass;dbn=your_db;en
g=your_server" -q
(filename).sql
> I am trying to create a sql script to run on our Sybase
> 12.6 server. The OS of the server is Red Hat Linux 3.0.
> I created a simple script using notepad with the following
> stored procedure in it.
>
> sp_iqlistlockedusers
; OUTPUT TO Jays_locked_accounts
.xls
> FORMAT EXCEL;
>
> I saved this file as (filename).sql. I placed this file
> on the Sybase server in the /home/sybase directory. The
> problem is I am not sure how to execute this script. Can
> someone please enlighten me? I am brand new to Sybase so
> please forgive me if this is a stupid request.
>
> Thanks.
| |
|
| basically you want to create a shell script that executes
dbisql that then executes your file...
create a shell script to execute something similiar to this:
dbisql -c
" uid=your_id;pwd=your
_pass;dbn=your_db;en
g=your_server" -q
(filename).sql
> I am trying to create a sql script to run on our Sybase
> 12.6 server. The OS of the server is Red Hat Linux 3.0.
> I created a simple script using notepad with the following
> stored procedure in it.
>
> sp_iqlistlockedusers
; OUTPUT TO Jays_locked_accounts
.xls
> FORMAT EXCEL;
>
> I saved this file as (filename).sql. I placed this file
> on the Sybase server in the /home/sybase directory. The
> problem is I am not sure how to execute this script. Can
> someone please enlighten me? I am brand new to Sybase so
> please forgive me if this is a stupid request.
>
> Thanks.
|
|
|
|