jpubs database

If you installed the Japanese Language Module with your Adaptive 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) or the Shift-JIS (sjis) character set.

StepsInstalling the jpubs database

To install the jpubs database:

  1. Set your terminal to display 8-bit characters.

  2. Verify that either the EUC-JIS or Shift-JIS character set is installed as Adaptive Server’s 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. See “Default devices for sample databases”.

  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 


    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.