Versions Compared

Key

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

...

simply copy and place into your preferred SQL tool

...

NOTE: This is NOT part of the normal data import process, this is used ONLY in case of errors, mistakes made, and data corrupted, and therefore a need to clean up the data just imported.

/*

If the data just uploaded is deemed to be corrupt or just very incorrect (example: incorrect SDR numbering) and we need to recode in some way, we might want to remove the data from WSDRS and make adjustments to M70 – or possibly purge m70 and return to the insert statements in DATA.TXT, recode and reprocess the data batch.

...