To use a translated or customized version of CA Dataquery, you must inform CA Dataquery on your User Profile.
The User Profile panel contains two language fields:
Use these fields to specify the language code assigned to the language you want to use.
The following is a sample User Profile panel:
User Profile
=> Overtype the values to be modified and press PF4 to complete the update ------------------------------------------------------------------------DQKL0 DATAQUERY: USER PROFILE FOR => LIZ ----------------------------------------------------------------------------- PROFILE ITEM EXPLANATION ----------------------------------------------------------------------------- DATADICTIONARY DATABASE ID => 00002 Five digit DB ID number for DD access LIST AND DISPLAY ALIASES => NO YES show aliases, NO suppress aliases GROUP DISPLAY => NO YES break out simple cols, NO do not SUPPRESS DUPLICATE COLUMNS => YES YES turn on suppression, NO turn off SUPPRESS PFKEYS ON PRINT => NO YES turn on suppression, NO turn off SUPPRESS EXECUTE PANEL => NO YES turn on suppression, NO turn off PRIMARY LANGUAGE => AE Two character PRIMARY Language ID SECONDARY LANGUAGE => AE Two character SECONDARY Language ID DECIMAL POINT CHARACTER => . Character to be used for decimal point QUERY LANGUAGE => DQL Language for queries - SQL or DQL SQL AUTHORIZATION ID => LIZ ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISP GROUPS <PF4> UPDATE <PF5> PRINT OPT <PF6> NOT USED <PF7> NOT USED <PF8> NOT USED
Action
Place your first language code choice in the primary language field and your second language code choice in the secondary language field.
If the SYSDIAL= and SYSLANG= parameters contain the language choices, you do not need to specify anything on the User Profile.
Anyone who wants to use a translated or customized version specifies that language code in their User Profile. Each user's profile can reflect their language choice. The possibilities for using the different language options on the User Profile make system customization easy. You can:
If the majority of the users at your site want to use a translated version, specify that language code in the SYSDIAL= parameter during installation.
Example
Using the scenario described in Language Codes, the following illustrates using User Profiles to further customize a company's system. Following are the codes available in the sample company:
|
Specification |
Code |
Description |
|---|---|---|
|
PRIMARY |
CO |
Company customization of translated language |
|
SECONDARY |
ES |
Complete translation to Spanish |
|
SYSDIAL= |
AC |
Company customization of American English |
|
SYSLANG= |
AE |
Majority of users are English speaking |
Two of the sample company's employees have different language needs:
The User Profile for HALL, (the American English user) would look like this:
=> Overtype the values to be modified and press PF4 to complete the update ------------------------------------------------------------------------DQKL0 DATAQUERY: USER PROFILE FOR => HALL ----------------------------------------------------------------------------- PROFILE ITEM EXPLANATION ----------------------------------------------------------------------------- DATADICTIONARY DATABASE ID => 00189 Five digit DB ID number for DD access LIST AND DISPLAY ALIASES => NO YES show aliases, NO suppress aliases GROUP DISPLAY => NO YES break out simple cols, NO do not SUPPRESS DUPLICATE COLUMNS => YES YES turn on suppression, NO turn off SUPPRESS PFKEYS ON PRINT => NO YES turn on suppression, NO turn off SUPPRESS EXECUTE PANEL => NO YES turn on suppression, NO turn off PRIMARY LANGUAGE => __ Two character PRIMARY Language ID SECONDARY LANGUAGE => __ Two character SECONDARY Language ID DECIMAL POINT CHARACTER => . Character to be used for decimal point QUERY LANGUAGE => DQL Language for queries - SQL or DQL SQL AUTHORIZATION ID => HALL ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISP GROUPS <PF4> UPDATE <PF5> PRINT OPT <PF6> NOT USED <PF7> NOT USED <PF8> NOT USED
Leaving the PRIMARY and SECONDARY fields blank allows CA Dataquery to default to the languages defined in SYSLANG= and SYSDIAL= of the CA Dataquery System Option Table.
The User Profile for Reyna (a Spanish-speaking employee) would look like this:
=> Overtype the values to be modified and press PF4 to complete the update ------------------------------------------------------------------------DQKL0 DATAQUERY: USER PROFILE FOR => REYNA ----------------------------------------------------------------------------- PROFILE ITEM EXPLANATION ----------------------------------------------------------------------------- DATADICTIONARY DATABASE ID => 00002 Five digit DB ID number for DD access LIST AND DISPLAY ALIASES => NO YES show aliases, NO suppress aliases GROUP DISPLAY => NO YES break out simple cols, NO do not SUPPRESS DUPLICATE COLUMNS => YES YES turn on suppression, NO turn off SUPPRESS PFKEYS ON PRINT => NO YES turn on suppression, NO turn off SUPPRESS EXECUTE PANEL => NO YES turn on suppression, NO turn off PRIMARY LANGUAGE => CO Two character PRIMARY Language ID SECONDARY LANGUAGE => ES Two character SECONDARY Language ID DECIMAL POINT CHARACTER => . Character to be used for decimal point QUERY LANGUAGE => DQL Language for queries - SQL or DQL SQL AUTHORIZATION ID => REYNA ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISP GROUPS <PF4> UPDATE <PF5> PRINT OPT <PF6> NOT USED <PF7> NOT USED <PF8> NOT USED
Reyna wants to use the company-wide customization of the Spanish translation (CO) and where an item has not been customized, he wants the translated version (ES).
It is also possible to install German as the SYSDIAL= language and specify AE for anyone who wants to execute CA Dataquery in American English.
Remember, you do not have to specify a language code in your user profile if the language you want to use has been specified in the SYSDIAL= parameter.
|
Copyright © 2014 CA.
All rights reserved.
|
|