KI_SET_LANGUAGES

Set database languages

Synopsis:
CALL KI_SET_LANGUAGES connection, SYM(lang()) TO status
status = 'ki_set_languages( connection, SYM(lang()) )
ArgumentEnumerationPurpose
connectionCurrent database connection
SYM(lang())Language array
statusKDB_ERROR_ENUMReturn status
>KI_SET_LANGUAGES

KI_SET_LANGUAGES

Allows configuration of the languages that the SQL database should support. For example:

MAT REDIM langs(2)
langs(1) = _KLANG_DE
langs(2) = _KLANG_ZH_MOD
CALL KI_SET_LANGUAGES connection, SYM(langs()) TO status

Configures the database for German and Simplified Chinese.

This provides an abstraction layer to a multi-lingual SQL database. We specify what languages the database should support then KCML will carry out the database specific operation required. On Oracle this may result in creating an index for each language. Where that index contains a column marked as a LANGUAGE column in the CREATE TABLE statement. If you add a language then all indexes must be recreated.

English(UK) is always included no matter what you specify. This function only has an affect on Oracle.

KI_GET_LANGUAGES can be used to retrieve the list of configured languages.

Use the KI_SET_LANGUAGE call to configure the current operating language.

History
Introduced in KCML 7.08
See Also:
KI_ALLOC_CONNECT, KI_CLEAR, KI_CONNECT, KI_CONNECT_GET_ATTR, KI_CONNECT_GET_ATTR_STR, KI_CONNECT_SET_ATTR, KI_CONNECT_SET_ATTR_STR, KI_DISCONNECT, KI_ERROR, KI_ERROR_TEXT, KI_FREE_CONNECT, KI_GET_ERROR_TEXT, KI_GET_LANGUAGES, KI_HANDLE_GET_ATTR_POOL, KI_INFO, KI_REDIR_CONNECT, KI_SET_LANGUAGE
KCML database status codes