error

Teradata Applications

error

Hi all,

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

query used:

CREATE MULTISET TABLE Database.RENEWALS

     (

      POL_REF VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,

      EP_DTE_START TIMESTAMP,

      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,

      RISK_PREM INTEGER)

PRIMARY INDEX ( POL_REF );

.set record vartext ",";

begin loading Database.RENEWALS

define

POL_REF (VARCHAR(12)),

EP_DTE_START (TIMESTAMP),

CLAIM_IND (CHAR(1)),

FLOOD_IND (CHAR(1)),

REN_PREM (CHAR(1)),

MISSING_DATA_IND (CHAR(1)),

RISK_PREM (INTEGER),

file=location.CSV;

1 REPLY
Teradata Employee

Re: error

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.