Macro to prevent false positive validation errors

In your SQL load queries, you can use the --<<DONT_USE_INSERTINTO>> macro to prevent false positive validation errors in queries. Use this macro if you execute a load query between the same source and target table. Specify the macro before you start specifying your SQL query.

Note: The --<<DONT_USE_VALIDATION>> macro, which was used to get only the first record from the validation result set, is no longer valid. In existing SQL statements, macro is treated as a comment and has no effect on queries. Therefore, it is not required to remove it.