I'm getting the below error while loading flat file to Table using FL facility. I'm new to TD and tried all the options to resolve the issue. But, no luck.
My input file (EMP_FLAT) looks like below:
My FL code is:
.SET RECORD UNFORMATTED;
DROP TABLE EREMP1;
DROP TABLE EREMP2;
DELETE FROM EMP;
BEGIN LOADING EMP ERRORFILES EREMP1,EREMP2 CHECKPOINT 5;
INSERT INTO EMP (EMPID, EMPNAME, EMPCODE, EMPSAL) VALUES (:EID, :ENM, :ECD, :ESAL);
The error being hitting is -->
0008 BEGIN LOADING FPARTY
ERRORFILES ERFPARTY, UVFPARTY
**** 21:47:35 Number of AMPs available: 2
**** 21:47:35 BEGIN LOADING COMPLETE
= Insert Phase =
0009 INSERT INTO FPARTY(PARTYID,PARTYNAME,PARTYCODE,PARTYINCOME)
**** 21:47:35 FDL4816 Statement rejected, cannot match elements with
I_PID is not defined
I_PNM is not defined
I_PCD is not defined
I_PINC is not defined
= Logoff/Disconnect =
Any inputs on this would be highly appreciated.
Thanks in Advance.
You need to remove the character ':' in front of the fields defined in the DEFINE command, it will become:
Also, the fields in the input record must match with the DEFINE command. With the above DEFINE command, each record has 13 characters; while in your data file, each record has only 10 characters.