This QMF Analytics for TSO sample
table provides data about geographic regions in which the J &
H Supply Company conducts business.
The columns are as follows:
COUNTRY ID
The three-digit numeric (ISO 3166-1) country code for the country
ALPHA 3
The three-letter (ISO 3166-1) country code for the country
ALPHA2
The two-letter (ISO 3166-1) country code for the country
COUNTRY
The country name
An excerpt of the Q.WORLDINFO table is shown
in the following figure: Figure 1. Excerpt
from the Q.WORLDINFO table
COUNTRY
ID ALPHA3 ALPHA2 COUNTRY
------- ------ ------ -------------------
4 AFG AF AFGHANISTAN
8 ALB AL ALBANIA
10 ATA AQ ANTARCTICA
12 DZA DZ ALGERIA
16 ASM AS AMERICAN SAMOA
20 AND AD ANDORRA
24 AGO AO ANGOLA
28 ATG AG ANTIGUA AND BARBUDA
31 AZE AZ AZERBAIJAN
32 ARG AR ARGENTINA
36 AUS AU AUSTRALIA
40 AUT AT AUSTRIA
44 BHS BS BAHAMAS
48 BHR BH BAHRAIN
50 BGD BD BANGLADESH
51 ARM AM ARMENIA
52 BRB BB BARBADOS
56 BEL BE BELGIUM
60 BMU BM BERMUDA
64 BTN BT BHUTAN
68 BOL BO BOLIVIA
70 BIH BA BOSNIA AND HERZEGOVINA
72 BWA BW BOTSWANA
74 BVT BV BOUVET ISLAND
76 BRA BR BRAZIL
84 BLZ BZ BELIZE
86 IOT IO BRITISH INDIAN OCEAN TERRITORY
90 SLB SB SOLOMON ISLANDS
92 VGB VG VIRGIN ISLANDS, BRITISH
96 BRN BN BRUNEI DARUSSALAM
100 BGR BG BULGARIA
104 MMR MM MYANMAR
108 BDI BI BURUNDI
112 BLR BY BELARUS
116 KHM KH CAMBODIA
120 CMR CM CAMEROON
124 CAN CA CANADA
132 CPV CV CAPE VERDE
136 CYM KY CAYMAN ISLANDS
140 CAF CF CENTRAL AFRICAN REPUBLIC
144 LKA LK SRI LANKA
148 TCD TD CHAD
152 CHL CL CHILE
156 CHN CN CHINA