Running a Reserved Word Check

Run the reserved word check on the old Adaptive Server.

  1. Install the Cluster Edition version of installupgrade (where $SYBASE and $SYBASE_ASE are the values for the Cluster Edition):
    isql -Usa -Ppassword -Sserver_name 
      -i$SYBASE/$SYBASE_ASE/scripts/installupgrade
  2. Install the Cluster Edition version of usage.sql:
    isql -Usa -Ppassword -Sserver_name 
       -i$SYBASE/$SYBASE_ASE/upgrade/usage.sql
  3. Log in to the old Adaptive Server and execute sp_checkreswords on all the databases. For example:
    use sybsystemprocs
    go
    sp_checkreswords
    go
  4. Correct any errors from the reserved word check.