I am facing an issue in executing below scritp through fast load utility for tab delimited .txt file.
1. First issue in .RECORD 1;
2. IF I remove .RECORD 1; from the code, I am getting "Specified string does not have matchSpecified string does not have match FDL4800 Invalid FastLoad statement"
Please help on this issue.
There's a missing semicolon:
.BEGIN LOADING TABLENAME;
.IMPORT INFILE name_arch FORMAT VARTEXT '09'XCV";
I am able to execute the script successfully now but 60% of records go to error table2 and only 40% records inserted into actual table. I am not able to find any difference in records inserted into error and actual table.
Please help to identify the issue.
Your target table has a Unique Primary Index and your input has multiple records with the same PI value. For each PI value, one row is loaded and the others go to Error Table 2.