Installing the interpubs Database

interpubs is similar to the pubs2 database, and contains French and German data.

Prerequisites
Make a copy of the original installintpubs script. Be sure you can access this copy, in case you experience problems with the edited script.
Task

The interpubs database contains 8-bit characters and is available for use at Adaptive Server installations using the ISO 8859-1 (iso_1), ISO 8859-15 (iso_15), Roman 8, or Roman9 (for HP-UX) character set. To display the French and German data correctly, you must set up your terminal to display 8-bit characters.

  1. Be sure iso_1, iso_15, Roman8, Roman 9, or UTF-8 is installed as the default character set or as an additional character set.
  2. Determine the type (raw partition, logical volume, operating system file, and so on) and location of the device where you will be storing the interpubs database. You will need to provide this information later.
  3. Use a text editor to edit the script, if necessary, specify a default device other than the master device, or use sp_diskdefault.
  4. Execute the script, using the -J flag to ensure that the database is installed with the correct character set:
    isql -Usa -Ppassword -Sservername -Jiso_1 \
     -i %SYBASE%\%SYBASE_ASE%\scripts\iso_1