Locale Environment Variables Universal Server utilities and SQL utilities are client applications that request information from an instance of Universal Server. Therefore, these utilities use the CLIENT_LOCALE, DB_LOCALE, and SERVER_LOCALE environment variables to obtain the name of a nondefault locale, as follows:
These utilities also perform code-set conversion if the database and the client locales support convertible code sets. For more information on code-set conversion, see page 1-40.
Non-ASCII Characters in Command-Line Arguments Most Universal Server utilities support non-ASCII characters in command-line arguments. These utilities interpret all command-line arguments in the client code set (which CLIENT_LOCALE defines). Figure 4-2 shows Universal Server utilities that accept non-ASCII characters in command-line arguments.
Figure 4-2 Universal Server Utilities That Accept Non-ASCII Characters in Command-Line Arguments Utility Name Non-ASCII Characters in Command-Line Argument Non-ASCII Output onaudit -f input_file Yes oncheck -cc -pc database -ci -cI -pk -pK -pl -pL database:table#index_name -ci -cI -pk -pK -pl -pL -cd -cD -pB -pt -pT -pd -pD -pp database:table Yes onload database:table -i old_index new_index -t tape_device Yes onlog -d tape_device None onshowaudit -f input_file -s server_name Yes onspaces -p pathname -f filename None onstat -o filename -dest filename_source Yes onunload database:table -t tape_device Yes
onaudit
-f input_file
Yes
oncheck
-cc -pc database
-ci -cI -pk -pK -pl -pL database:table#index_name
-ci -cI -pk -pK -pl -pL -cd -cD -pB -pt -pT -pd -pD -pp database:table
onload
database:table
-i old_index new_index
-t tape_device
onlog
-d tape_device
None
onshowaudit
-s server_name
onspaces
-p pathname
-f filename
onstat
-o filename -dest
filename_source
onunload
The following SQL utilities also accept non-ASCII characters in command-line arguments and generate any output in the client code set: