In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality.
It is recommended to go through LOAD DATA documentation first.
After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table
Below is the basic command when table is already created and source file does not contain header row.
LOAD DATA FROM FILE 'C://TEMP/mydata.txt'
The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns.
Loading from File Source: Header