Sample Query

It returns the language code to be used as the suffix of the column name. In the following Select statement, where French is the language, the macro generates the column name COUNTRY_FR.

Select
COUNTRY.COUNTRY_CODE,
#'COUNTRY.COUNTRY_' + $Language_lookup{$runLocale}# as
Product_Line
from
[great_outdoors].COUNTRY

Because Framework Manager is flexible, your multilingual columns do not have to use the naming system used in the samples. In fact, your multilingual columns can use any naming system. You can encode your naming scheme into the parameter map, as required. You can use any session variable as the parameter map key and return any SQL syntax that you require to substitute at run-time. For more information, see the Framework Manager User Guide.