I am trying to upload a file via FastLoad and it is giving me error-
**** 09:06:14 Duplicate element name - POL_RE
**** 09:06:14 FDL4822 DEFINE statement reject
**** 09:06:14 Invalid type for: EP_DTE_START
Could you please let me know where am i going wrong
CREATE MULTISET TABLE Database.RENEWALS
POL_REF VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
CLAIM_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
FLOOD_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
REN_PREM CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
MISSING_DATA_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
PRIMARY INDEX ( POL_REF );
.set record vartext ",";
begin loading Database.RENEWALS
The DEFINE describes the input data, not the target table. All the input fields should be defined as VARCHAR when RECORD type is VARTEXT.
For FastLoad, SET RECORD should not begin with a period.
You need a semicolon to end the BEGIN LOADING statement, and ERRORFILES specifications are required.
You will also need an INSERT statement and END LOADING.