Sybase 12.5.1, User Manual

Page: 112 / 210

Script file
98
Historical Server
Each column is assigned a datatype that is appropriate for the type of
information that the data item represents. All columns except the sample
timestamp column can contain null values.
Passing script file commands
You can pass the create table commands in the script file to Adaptive Server by
using the
isql
utility’s
:r
command. After the table is defined with the
:r
command, you can use the Bulk Copy utility to import the view data files into
the tables. For a Bulk Copy example, see “Bulk copy example” on page 99.
Script use example
Use the following
isql
command to connect to the Adaptive Server in which
you want to store the recorded monitoring data:
isql -U username -P password -S server
where username is the name of a login account in that Adaptive Server,
password is the password of that login account, and server is the Adaptive
Server name.
Execute the following
isql
commands:
use database
go
where database is the name of the database that will contain the new tables.
:r scriptfile
go
where scriptfile is the path name of the script file that was created by the
Historical Server.
A table now exists in the Adaptive Server for each view defined for the
recording session.