alter table COUNTRY add column THREE_LETTER_CODE varchar(10);

update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AFG' where COUNTRY.CODE = 'AF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ALB' where COUNTRY.CODE = 'AL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'DZA' where COUNTRY.CODE = 'DZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ASM' where COUNTRY.CODE = 'AS';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AND' where COUNTRY.CODE = 'AD';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AGO' where COUNTRY.CODE = 'AO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AIA' where COUNTRY.CODE = 'AI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ATA' where COUNTRY.CODE = 'AQ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ATG' where COUNTRY.CODE = 'AG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ARG' where COUNTRY.CODE = 'AR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ARM' where COUNTRY.CODE = 'AM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ABW' where COUNTRY.CODE = 'AW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AUS' where COUNTRY.CODE = 'AU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AUT' where COUNTRY.CODE = 'AT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'AZE' where COUNTRY.CODE = 'AZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BHS' where COUNTRY.CODE = 'BS';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BHR' where COUNTRY.CODE = 'BH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BGD' where COUNTRY.CODE = 'BD';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BRB' where COUNTRY.CODE = 'BB';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BLR' where COUNTRY.CODE = 'BY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BEL' where COUNTRY.CODE = 'BE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BLZ' where COUNTRY.CODE = 'BZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BEN' where COUNTRY.CODE = 'BJ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BMU' where COUNTRY.CODE = 'BM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BTN' where COUNTRY.CODE = 'BT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BOL' where COUNTRY.CODE = 'BO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BIH' where COUNTRY.CODE = 'BA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BWA' where COUNTRY.CODE = 'BW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BVT' where COUNTRY.CODE = 'BV';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BRA' where COUNTRY.CODE = 'BR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'IOT' where COUNTRY.CODE = 'IO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BRN' where COUNTRY.CODE = 'BN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BGR' where COUNTRY.CODE = 'BG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BFA' where COUNTRY.CODE = 'BF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'BDI' where COUNTRY.CODE = 'BI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KHM' where COUNTRY.CODE = 'KH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CMR' where COUNTRY.CODE = 'CM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CAN' where COUNTRY.CODE = 'CA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CPV' where COUNTRY.CODE = 'CV';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CYM' where COUNTRY.CODE = 'KY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CAF' where COUNTRY.CODE = 'CF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TCD' where COUNTRY.CODE = 'TD';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CHL' where COUNTRY.CODE = 'CL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CHN' where COUNTRY.CODE = 'CN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CXR' where COUNTRY.CODE = 'CX';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CCK' where COUNTRY.CODE = 'CC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'COL' where COUNTRY.CODE = 'CO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'COM' where COUNTRY.CODE = 'KM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'COG' where COUNTRY.CODE = 'CG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'COK' where COUNTRY.CODE = 'CK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CRI' where COUNTRY.CODE = 'CR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CIV' where COUNTRY.CODE = 'CI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'HRV' where COUNTRY.CODE = 'HR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CUB' where COUNTRY.CODE = 'CU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CYP' where COUNTRY.CODE = 'CY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CZE' where COUNTRY.CODE = 'CZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'DNK' where COUNTRY.CODE = 'DK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'DJI' where COUNTRY.CODE = 'DJ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'DMA' where COUNTRY.CODE = 'DM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'DOM' where COUNTRY.CODE = 'DO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TMP' where COUNTRY.CODE = 'TP';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ECU' where COUNTRY.CODE = 'EC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'EGY' where COUNTRY.CODE = 'EG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SLV' where COUNTRY.CODE = 'SV';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GNQ' where COUNTRY.CODE = 'GQ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ERI' where COUNTRY.CODE = 'ER';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'EST' where COUNTRY.CODE = 'EE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ETH' where COUNTRY.CODE = 'ET';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FLK' where COUNTRY.CODE = 'FK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FRO' where COUNTRY.CODE = 'FO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FJI' where COUNTRY.CODE = 'FJ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FIN' where COUNTRY.CODE = 'FI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FRA' where COUNTRY.CODE = 'FR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FXX' where COUNTRY.CODE = 'FX';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GUF' where COUNTRY.CODE = 'GF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PYF' where COUNTRY.CODE = 'PF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ATF' where COUNTRY.CODE = 'TF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GAB' where COUNTRY.CODE = 'GA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GMB' where COUNTRY.CODE = 'GM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GEO' where COUNTRY.CODE = 'GE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'DEU' where COUNTRY.CODE = 'DE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GHA' where COUNTRY.CODE = 'GH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GIB' where COUNTRY.CODE = 'GI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GRC' where COUNTRY.CODE = 'GR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GRL' where COUNTRY.CODE = 'GL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GRD' where COUNTRY.CODE = 'GD';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GLP' where COUNTRY.CODE = 'GP';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GUM' where COUNTRY.CODE = 'GU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GTM' where COUNTRY.CODE = 'GT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GIN' where COUNTRY.CODE = 'GN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GNB' where COUNTRY.CODE = 'GW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GUY' where COUNTRY.CODE = 'GY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'HTI' where COUNTRY.CODE = 'HT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'HMD' where COUNTRY.CODE = 'HM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'HND' where COUNTRY.CODE = 'HN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'HKG' where COUNTRY.CODE = 'HK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'HUN' where COUNTRY.CODE = 'HU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ISL' where COUNTRY.CODE = 'IS';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'IND' where COUNTRY.CODE = 'IN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'IDN' where COUNTRY.CODE = 'ID';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'IRN' where COUNTRY.CODE = 'IR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'IRQ' where COUNTRY.CODE = 'IQ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'IRL' where COUNTRY.CODE = 'IE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ISR' where COUNTRY.CODE = 'IL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ITA' where COUNTRY.CODE = 'IT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'JAM' where COUNTRY.CODE = 'JM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'JPN' where COUNTRY.CODE = 'JP';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'JOR' where COUNTRY.CODE = 'JO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KAZ' where COUNTRY.CODE = 'KZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KEN' where COUNTRY.CODE = 'KE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KIR' where COUNTRY.CODE = 'KI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PRK' where COUNTRY.CODE = 'KP';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KOR' where COUNTRY.CODE = 'KR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KWT' where COUNTRY.CODE = 'KW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KGZ' where COUNTRY.CODE = 'KG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LAO' where COUNTRY.CODE = 'LA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LVA' where COUNTRY.CODE = 'LV';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LBN' where COUNTRY.CODE = 'LB';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LSO' where COUNTRY.CODE = 'LS';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LBR' where COUNTRY.CODE = 'LR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LBY' where COUNTRY.CODE = 'LY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LIE' where COUNTRY.CODE = 'LI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LTU' where COUNTRY.CODE = 'LT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LUX' where COUNTRY.CODE = 'LU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MAC' where COUNTRY.CODE = 'MO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MKD' where COUNTRY.CODE = 'MK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MDG' where COUNTRY.CODE = 'MG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MWI' where COUNTRY.CODE = 'MW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MYS' where COUNTRY.CODE = 'MY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MDV' where COUNTRY.CODE = 'MV';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MLI' where COUNTRY.CODE = 'ML';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MLT' where COUNTRY.CODE = 'MT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MHL' where COUNTRY.CODE = 'MH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MTQ' where COUNTRY.CODE = 'MQ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MRT' where COUNTRY.CODE = 'MR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MUS' where COUNTRY.CODE = 'MU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MYT' where COUNTRY.CODE = 'YT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MEX' where COUNTRY.CODE = 'MX';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'FSM' where COUNTRY.CODE = 'FM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MDA' where COUNTRY.CODE = 'MD';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MCO' where COUNTRY.CODE = 'MC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MNG' where COUNTRY.CODE = 'MN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MSR' where COUNTRY.CODE = 'MS';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MAR' where COUNTRY.CODE = 'MA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MOZ' where COUNTRY.CODE = 'MZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MMR' where COUNTRY.CODE = 'MM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NAM' where COUNTRY.CODE = 'NA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NRU' where COUNTRY.CODE = 'NR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NPL' where COUNTRY.CODE = 'NP';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NLD' where COUNTRY.CODE = 'NL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ANT' where COUNTRY.CODE = 'AN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NCL' where COUNTRY.CODE = 'NC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NZL' where COUNTRY.CODE = 'NZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NIC' where COUNTRY.CODE = 'NI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NER' where COUNTRY.CODE = 'NE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NGA' where COUNTRY.CODE = 'NG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NIU' where COUNTRY.CODE = 'NU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NFK' where COUNTRY.CODE = 'NF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'MNP' where COUNTRY.CODE = 'MP';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'NOR' where COUNTRY.CODE = 'NO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'OMN' where COUNTRY.CODE = 'OM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PAK' where COUNTRY.CODE = 'PK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PLW' where COUNTRY.CODE = 'PW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PAN' where COUNTRY.CODE = 'PA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PNG' where COUNTRY.CODE = 'PG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PRY' where COUNTRY.CODE = 'PY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PER' where COUNTRY.CODE = 'PE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PHL' where COUNTRY.CODE = 'PH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PCN' where COUNTRY.CODE = 'PN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'POL' where COUNTRY.CODE = 'PL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PRT' where COUNTRY.CODE = 'PT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'PRI' where COUNTRY.CODE = 'PR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'QAT' where COUNTRY.CODE = 'QA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'REU' where COUNTRY.CODE = 'RE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ROM' where COUNTRY.CODE = 'RO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'RUS' where COUNTRY.CODE = 'RU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'RWA' where COUNTRY.CODE = 'RW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'KNA' where COUNTRY.CODE = 'KN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LCA' where COUNTRY.CODE = 'LC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VCT' where COUNTRY.CODE = 'VC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'WSM' where COUNTRY.CODE = 'WS';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SMR' where COUNTRY.CODE = 'SM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'STP' where COUNTRY.CODE = 'ST';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SAU' where COUNTRY.CODE = 'SA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SEN' where COUNTRY.CODE = 'SN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SYC' where COUNTRY.CODE = 'SC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SLE' where COUNTRY.CODE = 'SL';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SGP' where COUNTRY.CODE = 'SG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SVK' where COUNTRY.CODE = 'SK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SVN' where COUNTRY.CODE = 'SI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SLB' where COUNTRY.CODE = 'SB';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SOM' where COUNTRY.CODE = 'SO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ZAF' where COUNTRY.CODE = 'ZA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ESP' where COUNTRY.CODE = 'ES';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'LKA' where COUNTRY.CODE = 'LK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SHN' where COUNTRY.CODE = 'SH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SPM' where COUNTRY.CODE = 'PM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SDN' where COUNTRY.CODE = 'SD';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SUR' where COUNTRY.CODE = 'SR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SJM' where COUNTRY.CODE = 'SJ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SWZ' where COUNTRY.CODE = 'SZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SWE' where COUNTRY.CODE = 'SE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'CHE' where COUNTRY.CODE = 'CH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'SYR' where COUNTRY.CODE = 'SY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TWN' where COUNTRY.CODE = 'TW';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TJK' where COUNTRY.CODE = 'TJ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TZA' where COUNTRY.CODE = 'TZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'THA' where COUNTRY.CODE = 'TH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TGO' where COUNTRY.CODE = 'TG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TKL' where COUNTRY.CODE = 'TK';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TON' where COUNTRY.CODE = 'TO';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TTO' where COUNTRY.CODE = 'TT';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TUN' where COUNTRY.CODE = 'TN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TUR' where COUNTRY.CODE = 'TR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TKM' where COUNTRY.CODE = 'TM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TCA' where COUNTRY.CODE = 'TC';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'TUV' where COUNTRY.CODE = 'TV';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'UGA' where COUNTRY.CODE = 'UG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'UKR' where COUNTRY.CODE = 'UA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ARE' where COUNTRY.CODE = 'AE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'GBR' where COUNTRY.CODE = 'GB';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'USA' where COUNTRY.CODE = 'US';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'UMI' where COUNTRY.CODE = 'UM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'URY' where COUNTRY.CODE = 'UY';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'UZB' where COUNTRY.CODE = 'UZ';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VUT' where COUNTRY.CODE = 'VU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VAT' where COUNTRY.CODE = 'VA';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VEN' where COUNTRY.CODE = 'VE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VNM' where COUNTRY.CODE = 'VN';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VGB' where COUNTRY.CODE = 'VG';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'VIR' where COUNTRY.CODE = 'VI';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'WLF' where COUNTRY.CODE = 'WF';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ESH' where COUNTRY.CODE = 'EH';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'YEM' where COUNTRY.CODE = 'YE';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'YUG' where COUNTRY.CODE = 'YU';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ZAR' where COUNTRY.CODE = 'ZR';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ZMB' where COUNTRY.CODE = 'ZM';
update COUNTRY set COUNTRY.THREE_LETTER_CODE = 'ZWE' where COUNTRY.CODE = 'ZW';