langinstall

Installs a new language in an Adaptive Server.

The utility is located in:

(UNIX) $SYBASE/$SYBASE_ASE/bin.
(Windows) %SYBASE%\%SYBASE_ASE%\bin, as langinst.exe.

Syntax

langinstall
	[-I path]
	[-P password]
	[-R release_number]
	[-S server]
	[-U user]
	language
	character_set

langinstall -v

Parameters

-I path – specifies the name and location of the interfaces file (sql.ini file in Windows) that langinstall searches when connecting to Adaptive Server. If you do not specify -I, langinstall uses the interfaces file in the directory specified by the SYBASE environment variable. If SYBASE is not set, langinstall looks for the default SYBASE directory.
-P password – specifies the system administrator’s (“sa” account) password. If you omit -P, langinstall prompts for the “sa” account password.
-R release_number – specifies the release number, in the format n.n.n, to use to upgrade messages in master..sysmessages. Use -R only in failure conditions, such as if langinstall (langinst in Windows) fails, in case of user error, or when you think that messages in sysmessages are out of date.
The -R parameter forces langinstall to collect messages from a release previous to the current one. langinstall compares the existing messages with the ones to be installed and replaces any that have changed.

For example, if the current version is 15.0, and the previous version was 12.5, and you think sysmessages may not be correct, include the messages from the earlier version in the syslanguages.upgrade column (12.5 in this case) by specifying -R12.5. langinstall then installs all messages from Adaptive Server 12.5.
-S server – specifies the name of the Adaptive Server to which to connect. If you do not specify -S, langinstall uses the server specified by your DSQUERY environment variable. If DSQUERY is not set, langinstall attempts to connect to a server named SYBASE.
-U user – specifies a login name. Login names are case sensitive.
language – is the official name of the language to be installed. You must specify a language.
character_set – is the name of Adaptive Server default character set, and indicates the directory name of the localization files for the language. The common.loc and server.loc localization files for an official language reside in the character set directory $SYBASE/locales/language/character_set in UNIX platforms, or %SYBASE%\locales\language\character_set in Windows. You must specify a character set.
-v – prints the version number and copyright message for langinstall and then exits.

Usage

The Adaptive Server installation program runs langinstall automatically for a new installation as well as for customers who are upgrading from an earlier version.

langinstall:

Adds the specified language-specific information to master..syslanguages using sp_addlanguage. If the language already exists, langinstall updates the appropriate row in syslanguages.
Adds to, updates, and deletes error messages as necessary from master..sysmessages.
Updates syslanguages.update, inserting the new release number.
Validates the entries in the localization file sections that it uses. If anything is missing, langinstall prints an error message and does not add the language to syslanguages.
Compares the version numbers of each localization file it uses, common.loc and server.loc. If they are not the same, it prints a warning message. syslanguages.upgrade is always set according to the version number in server.loc.

Permissions

Only a system administrator using the “sa” account can run langinstall.

Tables used

master.dbo.syslanguages, master.dbo.sysmessages