Sybase Version 2.2 - Manual (Page 14)

Upgrading the PATRIOT database
8 PATRIOTcompliance Starter Kit
Windows example: JAVA_HOME=$JAGUAR\shared\sun\jdk\jdk.3
6 Set the PATRIOT environment variable. This is the directory where you
initially copied the contents of the PATRIOTcompliance Starter Kit
Solution Template CD.
Solaris example: PATRIOT=$PATRIOT
Windows example: PATRIOT=%PATRIOT%
Upgrading the PATRIOT database
Release 2.2 includes scripts that allow you to upgrade the PATRIOT database
(Patriotdb) and New Era of Networks database (NNSYdb). There are separate
instructions for Solaris and Windows-based installations.
Solaris Use these instructions to upgrade your database on Solaris.
1 Open a command window. Navigate to the
$PATRIOT/release2.2/database directory.
2 Execute the PatriotDB2.2_Upgrade.sql script, with the following syntax:
isql -S <ASE server name> -U <ASE_username> -P
<ASE_password> -i PatriotDB2.2_Upgrade.sql -o
3 Review and correct any errors in the output file.
Windows Use these instruction to upgrade your database on Windows.
1 Open a command window. Navigate to the %PATRIOT%\database
directory.
2 Execute the PatriotDB2.2_Upgrade.sql script, with the following syntax:
isql -S <ASE server name> -U <ASE_username> -P
<ASE_password> -i PatriotDB2.2_Upgrade.sql -o
3 Review and correct any errors in the output file.