fastload - FDL4822 DEFINE statement rejected.

Tools & Utilities
New Member

fastload - FDL4822 DEFINE statement rejected.

Try as I might, I cannot seem to get FASTLOAD to work... I keep getting FDL4822 DEFINE statement rejected as the error message... I have created the file many times over, had many columns, but down to 1... 

 

0002 define
TESTCOL1 (VARCHAR(10))
file = 'fl_test_.csv'

.begin loading grp_ai.fl_test errorfiles grp_ai.fl_test_ut, grp_ai.fl_test
_et;
**** 10:51:02 FDL4822 DEFINE statement rejected.
**** 10:51:02 Definition syntax error for: DEFINE
===================================================================


Here is the part of the fl file...

 

 

define
TESTCOL1 (VARCHAR(10))
file = 'fl_test_.csv'

.begin loading grp_ai.fl_test errorfiles grp_ai.fl_test_ut, grp_ai.fl_test_et;

insert into grp_ai.fl_test
values (
:TESTCOL1
);

.end loading;

logoff;

 

Any feedback would be greatly appreciated... 

1 REPLY

Re: fastload - FDL4822 DEFINE statement rejected.

 

I'm not sure you can use the . prefix for multi-line statements.  I think you need to use semicolon to end those statements instead. 

 

I think this would work:

 

DEFINE
TESTCOL1 (VARCHAR(10))
FILE=fl_test_.csv;

begin loading grp_ai.fl_test errorfiles grp_ai.fl_test_ut, grp_ai.fl_test_et;

insert into grp_ai.fl_test (TESTCOL1)
values (
:TESTCOL1
);

end loading;