Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

In order to later insert records into the M73_SDR_PRODUCT_MAKE_MODEL table, the minimum requirement is :

...

       AIRCRAFT_MODEL, AIRCRAFT_SERIAL_NUMBER,

 ‘UPDATE  'UPDATE M70_SDR_TRANSIT SET AIRCRAFT_MODEL = ''XXX'''     ||

...

    ' WHERE SDR_NUMBER_NUM = ''' || SDR_NUMBER_NUM || ''';' ||

 ‘UPDATE  'UPDATE M70_SDR_TRANSIT SET AIRCRAFT_MANUFACTURER = NULL' ||

...