This table lists the country or region names in each of the supported languages identified by LANGUAGE_ID. (Note that some of the entries may store the region name rather than the official country name in the NAME column for historical reasons.)
Column Description(s):
Column Name | Column Type | Description |
COUNTRYABBR |
CHAR(5) NOT NULL |
Country or region abbreviation code. This code is derived from the ISO-3166 Alpha-2 codes. For countries or regions with multiple commonly used names a number or letter may be appended to the ISO-3166 alpha-2 code to form the abbreviation code. |
LANGUAGE_ID |
INTEGER NOT NULL |
The language of the value in the NAME column. For a list of language components, see the LANGUAGE table. |
NAME |
VARCHAR(254) |
Name of the country or region in the language identified by LANGUAGE_ID. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031216480 |
COUNTRYABBR+LANGUAGE_ID |
Primary Key |
I0000342 |
LANGUAGE_ID+NAME |
Non-Unique Index |
I0000343 |
NAME |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_257 |
LANGUAGE_ID |
LANGUAGE |
LANGUAGE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.