ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/examples/scriptengine/tests/CreateCountriesTable.sql
Revision: 37
Committed: Mon Feb 15 14:44:25 2016 UTC (8 years, 9 months ago) by tony
Content type: application/sql
File size: 32632 byte(s)
Log Message: 
Committing updates for Release R1-4-0

File Contents

# User Rev Content
1 tony 37 CREATE Table COUNTRIES (
2     COUNTRY varchar(64) not null,
3     NonEU SmallInt,
4     ISO2 Char(2),
5     ISO3 Char(3),
6     Primary Key(COUNTRY)
7     );
8    
9     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Afghanistan', '1', 'AF', 'AFG') Matching (COUNTRY);
10     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Aland Islands', '1', 'AX', 'ALA') Matching (COUNTRY);
11     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Albania', '1', 'AL', 'ALB') Matching (COUNTRY);
12     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Algeria', '1', 'DZ', 'DZA') Matching (COUNTRY);
13     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('American Samoa', '1', 'AS', 'ASM') Matching (COUNTRY);
14     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Andorra', '1', 'AD', 'AND') Matching (COUNTRY);
15     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Angola', '1', 'AO', 'AGO') Matching (COUNTRY);
16     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Anguilla', '1', 'AI', 'AIA') Matching (COUNTRY);
17     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Antarctica', '1', 'AQ', 'ATA') Matching (COUNTRY);
18     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Antigua and Barbuda', '1', 'AG', 'ATG') Matching (COUNTRY);
19     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Argentina', '1', 'AR', 'ARG') Matching (COUNTRY);
20     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Armenia', '1', 'AM', 'ARM') Matching (COUNTRY);
21     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Aruba', '1', 'AW', 'ABW') Matching (COUNTRY);
22     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Australia', '1', 'AU', 'AUS') Matching (COUNTRY);
23     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Austria', '0', 'AT', 'AUT') Matching (COUNTRY);
24     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Azerbaijan', '1', 'AZ', 'AZE') Matching (COUNTRY);
25     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bahamas', '1', 'BS', 'BHS') Matching (COUNTRY);
26     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bahrain', '1', 'BH', 'BHR') Matching (COUNTRY);
27     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bangladesh', '1', 'BD', 'BGD') Matching (COUNTRY);
28     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Barbados', '1', 'BB', 'BRB') Matching (COUNTRY);
29     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Belarus', '1', 'BY', 'BLR') Matching (COUNTRY);
30     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Belgium', '0', 'BE', 'BEL') Matching (COUNTRY);
31     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Belize', '1', 'BZ', 'BLZ') Matching (COUNTRY);
32     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Benin', '1', 'BJ', 'BEN') Matching (COUNTRY);
33     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bermuda', '1', 'BM', 'BMU') Matching (COUNTRY);
34     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bhutan', '1', 'BT', 'BTN') Matching (COUNTRY);
35     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bolivia', '1', NULL, NULL) Matching (COUNTRY);
36     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bolivia, Plurinational State of', '1', 'BO', 'BOL') Matching (COUNTRY);
37     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bonaire, Saint Eustatius and Saba', '1', 'BQ', 'BES') Matching (COUNTRY);
38     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bosnia and Herzegovina', '1', 'BA', 'BIH') Matching (COUNTRY);
39     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Botswana', '1', 'BW', 'BWA') Matching (COUNTRY);
40     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bouvet Island', '1', 'BV', 'BVT') Matching (COUNTRY);
41     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Brazil', '1', 'BR', 'BRA') Matching (COUNTRY);
42     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('British Indian Ocean Territory', '1', 'IO', 'IOT') Matching (COUNTRY);
43     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Brunei Darussalam', '1', 'BN', 'BRN') Matching (COUNTRY);
44     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bulgaria', '1', 'BG', 'BGR') Matching (COUNTRY);
45     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Burkina Faso', '1', 'BF', 'BFA') Matching (COUNTRY);
46     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Burundi', '1', 'BI', 'BDI') Matching (COUNTRY);
47     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cambodia', '1', 'KH', 'KHM') Matching (COUNTRY);
48     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cameroon', '1', 'CM', 'CMR') Matching (COUNTRY);
49     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Canada', '1', 'CA', 'CAN') Matching (COUNTRY);
50     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cape Verde', '1', 'CV', 'CPV') Matching (COUNTRY);
51     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cayman Islands', '1', 'KY', 'CYM') Matching (COUNTRY);
52     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Central African Republic', '1', 'CF', 'CAF') Matching (COUNTRY);
53     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Chad', '1', 'TD', 'TCD') Matching (COUNTRY);
54     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Chile', '1', 'CL', 'CHL') Matching (COUNTRY);
55     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('China', '1', 'CN', 'CHN') Matching (COUNTRY);
56     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Christmas Island', '1', 'CX', 'CXR') Matching (COUNTRY);
57     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cocos (Keeling) Islands', '1', 'CC', 'CCK') Matching (COUNTRY);
58     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Colombia', '1', 'CO', 'COL') Matching (COUNTRY);
59     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Comoros', '1', 'KM', 'COM') Matching (COUNTRY);
60     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Congo', '1', 'CG', 'COG') Matching (COUNTRY);
61     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Congo, the Democratic Republic of the', '1', 'CD', 'COD') Matching (COUNTRY);
62     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cook Islands', '1', 'CK', 'COK') Matching (COUNTRY);
63     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Costa Rica', '1', 'CR', 'CRI') Matching (COUNTRY);
64     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cote d''Ivoire', '1', 'CI', NULL) Matching (COUNTRY);
65     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Croatia', '1', 'HR', 'HRV') Matching (COUNTRY);
66     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cuba', '1', 'CU', 'CUB') Matching (COUNTRY);
67     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Curaçao', '1', 'CW', 'CUW') Matching (COUNTRY);
68     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cyprus', '0', 'CY', 'CYP') Matching (COUNTRY);
69     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Czech Republic', '0', 'CZ', 'CZE') Matching (COUNTRY);
70     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Côte d''Ivoire', '1', NULL, 'CIV') Matching (COUNTRY);
71     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Democratic People''s Republic of Korea', '1', NULL, NULL) Matching (COUNTRY);
72     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Democratic Republic of the Congo', '1', NULL, NULL) Matching (COUNTRY);
73     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Denmark', '0', 'DK', 'DNK') Matching (COUNTRY);
74     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Djibouti', '1', 'DJ', 'DJI') Matching (COUNTRY);
75     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Dominica', '1', 'DM', 'DMA') Matching (COUNTRY);
76     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Dominican Republic', '1', 'DO', 'DOM') Matching (COUNTRY);
77     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ecuador', '1', 'EC', 'ECU') Matching (COUNTRY);
78     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Egypt', '1', 'EG', 'EGY') Matching (COUNTRY);
79     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('El Salvador', '1', 'SV', 'SLV') Matching (COUNTRY);
80     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('England', '0', NULL, NULL) Matching (COUNTRY);
81     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Equatorial Guinea', '1', 'GQ', 'GNQ') Matching (COUNTRY);
82     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Eritrea', '1', 'ER', 'ERI') Matching (COUNTRY);
83     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Estonia', '0', 'EE', 'EST') Matching (COUNTRY);
84     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ethiopia', '1', 'ET', 'ETH') Matching (COUNTRY);
85     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Falkland Islands (Malvinas)', '1', 'FK', 'FLK') Matching (COUNTRY);
86     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Faroe Islands', '1', 'FO', 'FRO') Matching (COUNTRY);
87     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Federated States of Micronesia', '1', NULL, NULL) Matching (COUNTRY);
88     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Fiji', '1', 'FJ', 'FJI') Matching (COUNTRY);
89     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Finland', '0', 'FI', 'FIN') Matching (COUNTRY);
90     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('France', '0', 'FR', 'FRA') Matching (COUNTRY);
91     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('French Guiana', '1', 'GF', 'GUF') Matching (COUNTRY);
92     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('French Polynesia', '1', 'PF', 'PYF') Matching (COUNTRY);
93     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('French Southern Territories', '1', 'TF', 'ATF') Matching (COUNTRY);
94     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Gabon', '1', 'GA', 'GAB') Matching (COUNTRY);
95     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Gambia', '1', 'GM', 'GMB') Matching (COUNTRY);
96     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Georgia', '1', 'GE', 'GEO') Matching (COUNTRY);
97     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Germany', '0', 'DE', 'DEU') Matching (COUNTRY);
98     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ghana', '1', 'GH', 'GHA') Matching (COUNTRY);
99     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Gibraltar', '1', 'GI', 'GIB') Matching (COUNTRY);
100     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Greece', '0', 'GR', 'GRC') Matching (COUNTRY);
101     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Greenland', '1', 'GL', 'GRL') Matching (COUNTRY);
102     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Grenada', '1', 'GD', 'GRD') Matching (COUNTRY);
103     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guadeloupe', '1', 'GP', 'GLP') Matching (COUNTRY);
104     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guam', '1', 'GU', 'GUM') Matching (COUNTRY);
105     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guatemala', '1', 'GT', 'GTM') Matching (COUNTRY);
106     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guernsey', '1', 'GG', 'GGY') Matching (COUNTRY);
107     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guinea', '1', 'GN', 'GIN') Matching (COUNTRY);
108     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guinea-Bissau', '1', 'GW', 'GNB') Matching (COUNTRY);
109     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guyana', '1', 'GY', 'GUY') Matching (COUNTRY);
110     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Haiti', '1', 'HT', 'HTI') Matching (COUNTRY);
111     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Heard Island and McDonald Islands', '1', 'HM', 'HMD') Matching (COUNTRY);
112     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Holy See (Vatican City State)', '1', 'VA', 'VAT') Matching (COUNTRY);
113     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Honduras', '1', 'HN', 'HND') Matching (COUNTRY);
114     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Hong Kong', '1', 'HK', 'HKG') Matching (COUNTRY);
115     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Hungary', '0', 'HU', 'HUN') Matching (COUNTRY);
116     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Iceland', '1', 'IS', 'ISL') Matching (COUNTRY);
117     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('India', '1', 'IN', 'IND') Matching (COUNTRY);
118     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Indonesia', '1', 'ID', 'IDN') Matching (COUNTRY);
119     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Iran, Islamic Republic of', '1', 'IR', 'IRN') Matching (COUNTRY);
120     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Iraq', '1', 'IQ', 'IRQ') Matching (COUNTRY);
121     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ireland', '0', 'IE', 'IRL') Matching (COUNTRY);
122     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Isle of Man', '1', 'IM', 'IMN') Matching (COUNTRY);
123     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Israel', '1', 'IL', 'ISR') Matching (COUNTRY);
124     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Italy', '0', 'IT', 'ITA') Matching (COUNTRY);
125     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ivory Coast', '1', NULL, NULL) Matching (COUNTRY);
126     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Jamaica', '1', 'JM', 'JAM') Matching (COUNTRY);
127     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Japan', '1', 'JP', 'JPN') Matching (COUNTRY);
128     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Jersey', '1', 'JE', 'JEY') Matching (COUNTRY);
129     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Jordan', '1', 'JO', 'JOR') Matching (COUNTRY);
130     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kazakhstan', '1', 'KZ', 'KAZ') Matching (COUNTRY);
131     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kenya', '1', 'KE', 'KEN') Matching (COUNTRY);
132     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kiribati', '1', 'KI', 'KIR') Matching (COUNTRY);
133     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Korea', '1', NULL, NULL) Matching (COUNTRY);
134     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Korea, Democratic People''s Republic of', '1', 'KP', 'PRK') Matching (COUNTRY);
135     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Korea, Republic of', '1', 'KR', 'KOR') Matching (COUNTRY);
136     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kosovo', '1', NULL, NULL) Matching (COUNTRY);
137     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kuwait', '1', 'KW', 'KWT') Matching (COUNTRY);
138     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kyrgyzstan', '1', 'KG', 'KGZ') Matching (COUNTRY);
139     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lao People''s Democratic Republic', '1', 'LA', 'LAO') Matching (COUNTRY);
140     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Latvia', '0', 'LV', 'LVA') Matching (COUNTRY);
141     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lebanon', '1', 'LB', 'LBN') Matching (COUNTRY);
142     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lesotho', '1', 'LS', 'LSO') Matching (COUNTRY);
143     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Liberia', '1', 'LR', 'LBR') Matching (COUNTRY);
144     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Libyan Arab Jamahiriya', '1', 'LY', 'LBY') Matching (COUNTRY);
145     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Liechtenstein', '1', 'LI', 'LIE') Matching (COUNTRY);
146     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lithuania', '0', 'LT', 'LTU') Matching (COUNTRY);
147     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Luxembourg', '0', 'LU', 'LUX') Matching (COUNTRY);
148     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Macao', '1', 'MO', 'MAC') Matching (COUNTRY);
149     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Macedonia, the former Yugoslav Republic of', '1', 'MK', 'MKD') Matching (COUNTRY);
150     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Madagascar', '1', 'MG', 'MDG') Matching (COUNTRY);
151     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Malawi', '1', 'MW', 'MWI') Matching (COUNTRY);
152     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Malaysia', '1', 'MY', 'MYS') Matching (COUNTRY);
153     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Maldives', '1', 'MV', 'MDV') Matching (COUNTRY);
154     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mali', '1', 'ML', 'MLI') Matching (COUNTRY);
155     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Malta', '0', 'MT', 'MLT') Matching (COUNTRY);
156     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Marshall Islands', '1', 'MH', 'MHL') Matching (COUNTRY);
157     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Martinique', '1', 'MQ', 'MTQ') Matching (COUNTRY);
158     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mauritania', '1', 'MR', 'MRT') Matching (COUNTRY);
159     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mauritius', '1', 'MU', 'MUS') Matching (COUNTRY);
160     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mayotte', '1', 'YT', 'MYT') Matching (COUNTRY);
161     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mexico', '1', 'MX', 'MEX') Matching (COUNTRY);
162     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Micronesia, Federated States of', '1', 'FM', 'FSM') Matching (COUNTRY);
163     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Moldova, Republic of', '1', 'MD', 'MDA') Matching (COUNTRY);
164     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Monaco', '0', 'MC', 'MCO') Matching (COUNTRY);
165     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mongolia', '1', 'MN', 'MNG') Matching (COUNTRY);
166     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Montenegro', '0', 'ME', 'MNE') Matching (COUNTRY);
167     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Montserrat', '1', 'MS', 'MSR') Matching (COUNTRY);
168     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Morocco', '1', 'MA', 'MAR') Matching (COUNTRY);
169     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mozambique', '1', 'MZ', 'MOZ') Matching (COUNTRY);
170     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Myanmar', '1', 'MM', 'MMR') Matching (COUNTRY);
171     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Namibia', '1', 'NA', 'NAM') Matching (COUNTRY);
172     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nauru', '1', 'NR', 'NRU') Matching (COUNTRY);
173     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nepal', '1', 'NP', 'NPL') Matching (COUNTRY);
174     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Netherlands', '1', 'NL', 'NLD') Matching (COUNTRY);
175     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('New Caledonia', '1', 'NC', 'NCL') Matching (COUNTRY);
176     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('New Zealand', '1', 'NZ', 'NZL') Matching (COUNTRY);
177     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nicaragua', '1', 'NI', 'NIC') Matching (COUNTRY);
178     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Niger', '1', 'NE', 'NER') Matching (COUNTRY);
179     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nigeria', '1', 'NG', 'NGA') Matching (COUNTRY);
180     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Niue', '1', 'NU', 'NIU') Matching (COUNTRY);
181     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Norfolk Island', '1', 'NF', 'NFK') Matching (COUNTRY);
182     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Northern Ireland', '0', NULL, NULL) Matching (COUNTRY);
183     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Northern Mariana Islands', '1', 'MP', 'MNP') Matching (COUNTRY);
184     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Norway', '1', 'NO', 'NOR') Matching (COUNTRY);
185     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Oman', '1', 'OM', 'OMN') Matching (COUNTRY);
186     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Pakistan', '1', 'PK', 'PAK') Matching (COUNTRY);
187     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Palau', '1', 'PW', 'PLW') Matching (COUNTRY);
188     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Palestinian Territory, Occupied', '1', 'PS', 'PSE') Matching (COUNTRY);
189     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Panama', '1', 'PA', 'PAN') Matching (COUNTRY);
190     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Papua New Guinea', '1', 'PG', 'PNG') Matching (COUNTRY);
191     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Paraguay', '1', 'PY', 'PRY') Matching (COUNTRY);
192     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Peru', '1', 'PE', 'PER') Matching (COUNTRY);
193     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Philippines', '1', 'PH', 'PHL') Matching (COUNTRY);
194     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Pitcairn', '1', 'PN', 'PCN') Matching (COUNTRY);
195     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Poland', '0', 'PL', 'POL') Matching (COUNTRY);
196     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Portugal', '0', 'PT', 'PRT') Matching (COUNTRY);
197     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Puerto Rico', '1', 'PR', 'PRI') Matching (COUNTRY);
198     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Qatar', '1', 'QA', 'QAT') Matching (COUNTRY);
199     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Republic of Palau', '1', NULL, NULL) Matching (COUNTRY);
200     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Reunion', '1', NULL, NULL) Matching (COUNTRY);
201     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Romania', '1', 'RO', 'ROU') Matching (COUNTRY);
202     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Russian Federation', '1', 'RU', 'RUS') Matching (COUNTRY);
203     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Rwanda', '1', 'RW', 'RWA') Matching (COUNTRY);
204     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Réunion', '1', 'RE', 'REU') Matching (COUNTRY);
205     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Barthélemy', '1', 'BL', 'BLM') Matching (COUNTRY);
206     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Helena, Ascension and Tristan da Cunha', '1', 'SH', 'SHN') Matching (COUNTRY);
207     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Kitts and Nevis', '1', 'KN', 'KNA') Matching (COUNTRY);
208     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Lucia', '1', 'LC', 'LCA') Matching (COUNTRY);
209     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Martin (French part)', '1', 'MF', 'MAF') Matching (COUNTRY);
210     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Pierre and Miquelon', '1', 'PM', 'SPM') Matching (COUNTRY);
211     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Vincent and the Grenadines', '1', 'VC', 'VCT') Matching (COUNTRY);
212     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Samoa', '1', 'WS', 'WSM') Matching (COUNTRY);
213     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('San Marino', '0', 'SM', 'SMR') Matching (COUNTRY);
214     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sao Tome and Principe', '1', 'ST', 'STP') Matching (COUNTRY);
215     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saudi Arabia', '1', 'SA', 'SAU') Matching (COUNTRY);
216     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Scotland', '0', NULL, NULL) Matching (COUNTRY);
217     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Senegal', '1', 'SN', 'SEN') Matching (COUNTRY);
218     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Serbia', '1', 'RS', 'SRB') Matching (COUNTRY);
219     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Seychelles', '1', 'SC', 'SYC') Matching (COUNTRY);
220     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sierra Leone', '1', 'SL', 'SLE') Matching (COUNTRY);
221     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Singapore', '1', 'SG', 'SGP') Matching (COUNTRY);
222     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sint Maarten (Dutch part)', '1', 'SX', 'SXM') Matching (COUNTRY);
223     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Slovakia', '1', 'SK', 'SVK') Matching (COUNTRY);
224     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Slovenia', '0', 'SI', 'SVN') Matching (COUNTRY);
225     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Solomon Islands', '1', 'SB', 'SLB') Matching (COUNTRY);
226     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Somalia', '1', 'SO', 'SOM') Matching (COUNTRY);
227     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('South Africa', '1', 'ZA', 'ZAF') Matching (COUNTRY);
228     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('South Georgia and the South Sandwich Islands', '1', 'GS', 'SGS') Matching (COUNTRY);
229     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('South Korea', '1', NULL, NULL) Matching (COUNTRY);
230     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Spain', '0', 'ES', 'ESP') Matching (COUNTRY);
231     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sri Lanka', '1', 'LK', 'LKA') Matching (COUNTRY);
232     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sudan', '1', 'SD', 'SDN') Matching (COUNTRY);
233     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Suriname', '1', 'SR', 'SUR') Matching (COUNTRY);
234     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Svalbard and Jan Mayen', '1', 'SJ', 'SJM') Matching (COUNTRY);
235     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Swaziland', '1', 'SZ', 'SWZ') Matching (COUNTRY);
236     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sweden', '0', 'SE', 'SWE') Matching (COUNTRY);
237     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Switzerland', '1', 'CH', 'CHE') Matching (COUNTRY);
238     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Syrian Arab Republic', '1', 'SY', 'SYR') Matching (COUNTRY);
239     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tahiti', '1', NULL, NULL) Matching (COUNTRY);
240     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Taiwan', '1', 'TW', 'TWN') Matching (COUNTRY);
241     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tajikistan', '1', 'TJ', 'TJK') Matching (COUNTRY);
242     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tanzania, United Republic of', '1', 'TZ', 'TZA') Matching (COUNTRY);
243     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Thailand', '1', 'TH', 'THA') Matching (COUNTRY);
244     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Timor-Leste', '1', 'TL', 'TLS') Matching (COUNTRY);
245     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Togo', '1', 'TG', 'TGO') Matching (COUNTRY);
246     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tokelau', '1', 'TK', 'TKL') Matching (COUNTRY);
247     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tonga', '1', 'TO', 'TON') Matching (COUNTRY);
248     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Trinidad and Tobago', '1', 'TT', 'TTO') Matching (COUNTRY);
249     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tunisia', '1', 'TN', 'TUN') Matching (COUNTRY);
250     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Turkey', '1', 'TR', 'TUR') Matching (COUNTRY);
251     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Turkmenistan', '1', 'TM', 'TKM') Matching (COUNTRY);
252     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Turks and Caicos Islands', '1', 'TC', 'TCA') Matching (COUNTRY);
253     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tuvalu', '1', 'TV', 'TUV') Matching (COUNTRY);
254     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Uganda', '1', 'UG', 'UGA') Matching (COUNTRY);
255     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ukraine', '1', 'UA', 'UKR') Matching (COUNTRY);
256     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United Arab Emirates', '1', 'AE', 'ARE') Matching (COUNTRY);
257     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United Kingdom', '0', 'GB', 'GBR') Matching (COUNTRY);
258     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United States', '1', 'US', 'USA') Matching (COUNTRY);
259     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United States Minor Outlying Islands', '1', 'UM', 'UMI') Matching (COUNTRY);
260     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Uruguay', '1', 'UY', 'URY') Matching (COUNTRY);
261     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Uzbekistan', '1', 'UZ', 'UZB') Matching (COUNTRY);
262     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Vanuatu', '1', 'VU', 'VUT') Matching (COUNTRY);
263     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Venezuela', '1', NULL, NULL) Matching (COUNTRY);
264     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Venezuela, Bolivarian Republic of', '1', 'VE', 'VEN') Matching (COUNTRY);
265     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Viet Nam', '1', 'VN', 'VNM') Matching (COUNTRY);
266     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Virgin Islands, British', '1', 'VG', 'VGB') Matching (COUNTRY);
267     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Virgin Islands, U.S.', '1', 'VI', 'VIR') Matching (COUNTRY);
268     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Wales', '0', NULL, NULL) Matching (COUNTRY);
269     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Wallis and Futuna', '1', 'WF', 'WLF') Matching (COUNTRY);
270     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Western Sahara', '1', 'EH', 'ESH') Matching (COUNTRY);
271     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Yemen', '1', 'YE', 'YEM') Matching (COUNTRY);
272     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Zambia', '1', 'ZM', 'ZMB') Matching (COUNTRY);
273     UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Zimbabwe', '1', 'ZW', 'ZWE') Matching (COUNTRY);
274     Commit;
275     Select * From COUNTRIES;