/
STEP 1 Empty the temp data table M70

STEP 1 Empty the temp data table M70

From table M70_SDR_TRANSIT, take a note what the latest date that the previous data was imported.

 

/
DELETE FROM M70_SDR_TRANSIT;
commit ;
/Step 1

Related content

Importing FAA "SDR" Data to CAWIS
Importing FAA "SDR" Data to CAWIS
Read with this
STEP 33 BACKOUT ?
STEP 33 BACKOUT ?
More like this
STEP 31 SDR INSERT ROUTINES
STEP 31 SDR INSERT ROUTINES
More like this
STEP 26 WHEN_DISCOVERED and HOW_DISCOVERED
STEP 26 WHEN_DISCOVERED and HOW_DISCOVERED
More like this
Exam Transferred but the same Exam is still on to be transferred list
Exam Transferred but the same Exam is still on to be transferred list
More like this
STEP 7 Make INSERT statements
STEP 7 Make INSERT statements
More like this