Each row of this table maps the country or region abbreviation code representing a country or region to a numeric code. The mapping is dictated by the third-party product or vendor identified by the string in the PRODUCTVENDOR column.
Column Description(s):
Column Name | Column Type | Description |
PRODUCTVENDOR |
VARCHAR(64) NOT NULL |
String that identifies the third-party product or vendor using this country code for the country or region identified by this country or region abbreviation code. |
COUNTRYABBR |
CHAR(5) NOT NULL |
Country or region abbreviation code for the country or region. The name of the country or region are stored in the COUNTRY table. |
COUNTRYCODE |
CHAR(5) |
The internal country or region code for the specified country or region assigned by the third party product or vendor. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031216360 |
PRODUCTVENDOR+COUNTRYABBR |
Primary Key |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.