Fast Load Error : FDL4822 DEFINE statement rejected.

Database
Fan

Fast Load Error : FDL4822 DEFINE statement rejected.

Hi All,

Can some one please look into thie below script and help to understant the cause of the error.

Error:- 

**** 04:34:59 FDL4822 DEFINE statement rejected.

**** 04:34:59 Definition syntax error for: 

.sessions 32;

.sleep 2;

.tenacity 4;

.RUN FILE /fs1/.logon_tbp.sh

.set record vartext "|" DISPLAY_ERRORS NOSTOP;

drop table ts_load_tbls.tbp_stg_err1;

drop table ts_load_tbls.tbp_stg_err2;

delete from ts_load_tbls.tbp_stg all;

begin loading ts_load_tbls.tbp_stg

errorfiles ts_load_tbls.tbp_stg_err1,

 ts_load_tbls.tbp_stg_err2;

DEFINE

bch_srl (varchar(10)),

bch_tmstmp (varchar(20)),

commit_timestamp (varchar(30)),

optype (varchar(3)),

jur_sp_cd (varchar(1)),

jur_oth_cd (varchar(1)),

tax_cny_cd (varchar(3))

file = /fs1/gp/npp.unl;

INSERT INTO ts_load_tbls.tbp_stg

(

:bch_srl,

:bch_tmstmp,

:commit_timestamp,

:optype,

:jur_sp_cd,

:jur_oth_cd,

:tax_cny_cd

);

end loading;

LOGOFF;

quit;
Tags (1)
3 REPLIES
Junior Supporter

Re: Fast Load Error : FDL4822 DEFINE statement rejected.

Hi.

The word 'VALUES' is missing before the fields between parenthesis.

BTW: the last quit is redundant after the logoff.

Cheers.

Carlos.

Fan

Re: Fast Load Error : FDL4822 DEFINE statement rejected.

Thanks Carlos,

Missing 'VALUES' doesn't help.

Error seems to be in DEFINE statement.

Error:- 

**** 04:34:59 FDL4822 DEFINE statement rejected.

**** 04:34:59 Definition syntax error for: 


Regards,

Sang

Junior Supporter

Re: Fast Load Error : FDL4822 DEFINE statement rejected.

Hi.

The script looks good.

Check if it has rubbish characters in the script file or, even better, create a brand new script file from scratch (no copy / paste).

HTH.

Cheers.

Carlos.