Installing online help for Transact-SQL syntax
26
/* is the space left on the default database devices
> size of model? */
if (select sum (high-low + 1)from sysdevices
where status & 1 = 1) - (select sum(size) from
sysusage, sysdevices
where vstart >= sysdevices.low
and vstart <= sysdevices.high
and sysdevices.status &1 = 1) >
(select sum(sysusages.size)
from sysusages where dbid =
3
begin
create database sybsyntax
end
else
begin
print "There is not enough room on the default
devices to create the sybsyntax database."
return
end
end
• After you have commented out this entire section, add this line to the
script:
create database sybsyntax on device_name
where device_name is the name of the device on which you want to install
sybsyntax.
• Execute:
isql -Usa -Ppassword -Sservername
-i$SYBASE/$SYBASE_ASE/scripts/ins_syn_sql
where sa is the user ID of the System Administrator, password is the
System Administrator’s password, and servername is the Adaptive Server
on which you plan to install the database.
To ensure that you have installed the sybsyntax database and that it is
working correctly, use isql to log in to the server on which you installed the
database, and execute sp_syntax. For example:
isql -Usa -Ppassword -Sservername
1> sp_syntax "select"
2> go