HP 3000 Manuals HP 3000 Manuals
Native Language Support HP ALLBASE/SQL supports native languages. This includes sorting and comparison of data stored as 8-bit or 16-bit native language characters in a DBEnvironment. HP ALLBASE/SQL allows the data language of an SQL database - specified with the START DBE NEW command - to be overwritten for specific tables and columns. This means HP ALLBASE/SQL permits a combination of one local language and the default language NATIVE-3000 for storing data within one DBEnvironment. HP ALLBASE/BRW supports native languages for data stored as 8-bit characters. This includes sorting but not data comparison. The data language to be used for sorting by HP ALLBASE/BRW is defined by the user via the JCW (job control word) NLDATALANG or via the BRWSETUP program in the Data Language field of the Global Values screen. If the language specified with a DBEnvironment in HP ALLBASE/SQL differs from the one specified in BRW, HP ALLBASE/BRW's execution program generates a warning, but executes the report. The warning message states: "Language of DBE <dbe name> differs from BRW's data language." HP ALLBASE/SQL also provides support of native language for SQL object names, for example table or column names. This is not supported by HP ALLBASE/BRW, therefore HP SQL tables and columns that are to be accessed by HP ALLBASE/BRW cannot contain native language characters in their names.