Category: Definition

Script

The term script (lat. scribere: to write) in an Adaptive Server® Enterprise environment describes a file which contains commands in T-SQL and can be executed using isql.

Example of the contents of a script:

    -- example_script.sql

    

    use master

    go

    

    select * from sysprocesses

    select * from syslogshold

    go

    

    use user_db

    go

    

    select db_name()

    go

    

    

Example for using an sql script

    isql -U sa -S <ASE_server_name>

      -i example_script.sql

      -o example_script.out

    

    

The script can be run against the ASE® using isql. The output is redirected into a seperate file using the -o- flag.