What steps will you take if the Fast Load Script does not run in a rel

1.	What steps will you take if the Fast Load Script does not run in a reliable manner?
Answer» In the event the Fast Load Script does not work for you, and only the error tables are available to you, then there are two WAYS to restart: Getting the OLD file to run again: Be sure not to completely remove the error tables. Instead, fix the errors in the script or file, and then execute it again. Running a new file: ALTERNATIVELY, you can restart by using the ending LOADING and beginning statements. As a consequence, the lock that was put on the target table can be removed and the record can also be removed from the fast-log table. If that works, you can run the whole script again. Or, you might DROP the table and recreate it.

What steps will you take if the Fast Load Script does not run in a reliable manner?

Answer»

In the event the Fast Load Script does not work for you, and only the error tables are available to you, then there are two WAYS to restart:

Getting the OLD file to run again: Be sure not to completely remove the error tables. Instead, fix the errors in the script or file, and then execute it again.
Running a new file: ALTERNATIVELY, you can restart by using the ending LOADING and beginning statements. As a consequence, the lock that was put on the target table can be removed and the record can also be removed from the fast-log table. If that works, you can run the whole script again. Or, you might DROP the table and recreate it.