Installing the Jpubs Database

Learn how to install the Jpubs database here.

Note: If you installed the Japanese Language Module with your server, the scripts file contains the installjpubs script for installing the jpubs database. jpubs is a database similar to pubs2 that contains Japanese data. installjpubs uses either the EUC-JIS (eucjis), UTF-8 (utf8), or the Shift-JIS (sjis) character sets.
  1. Set your terminal to display 8-bit characters.
  2. Verify that either the EUC-JIS, Shift-JIS, or the UTF-8 character set is installed as the Adaptive Server default character set or as an additional character set.
  3. Determine the type (raw partition, logical volume, operating system file, and so on) and location of the device where you will be storing the jpubs database. You will need to provide this information later.
  4. Make a copy of the original installjpubs script. Be sure that you can access this copy, in case you experience problems with the edited script.
  5. Use a text editor to edit the script, if necessary, to specify a default device other than the master device, or use sp_diskdefault.
  6. Execute the installjpubs script, using the -J flag to ensure that the database is installed with the correct character set: 
    isql -Usa -Ppassword -Sservername -Jeucjis \
 -i $SYBASE/$SYBASE_ASE/scripts/eucjis/installjpubs
    isql -Usa -Ppassword -Sservername -Jeucjis \
 -i %SYBASE%\%SYBASE_ASE%\scripts\eucjis\installjpubs
    or: 
    isql -Usa -Ppassword -Sservername -Jsjis \
 -i $SYBASE/$SYBASE_ASE/scripts/sjis/installjpubs
    isql -Usa -Ppassword -Sservername -Jsjis \
 -i %SYBASE%\%SYBASE_ASE%\scripts\sjis\installjpubs

    For more information on the -J option in isql, see the Utility Guide.

Parent topic: Installing Sample Databases