STEP 22 REGION CODE

Sept 2021 : NOTE - all required code for this process is found at :

FAA DATA IMPORT PROCEDURE.TXT

simply copy and place into your preferred SQL tool

/*

If REGION code is not found on CAWIS tables, the default is US

*/

UPDATE M70_SDR_TRANSIT M70

SET    M70.REGION_CODE = 'US'

WHERE  NOT EXISTS

(SELECT 1 FROM TR02_REGION TR02

 WHERE  TR02.TC_REGION_CD = NVL(M70.REGION_CODE,'X')) ;

COMMIT ;

/*