Multiload Accept Error

Database
Enthusiast

Multiload Accept Error

Hi I am trying to Run Multiload by exporting date in a file and then using it...
Following is the code i am running

.EXPORT REPORT DDNAME DELDATE

sel end_date (title '') from tableA;
.EXPORT RESET

while using in MULTILOAD i am giving as

.ACCEPT DELDTE FROM FILE DELDATE;

DELETE FROM TABLE B WHERE CURRENT_DATE<(&DELDTE-10);

but it is replacing it as
DELETE FROM TABLE B WHERE CURRENT_DATE<(2009-10);
And coming out with an error.
but it shud be
DELETE FROM TABLE B WHERE CURRENT_DATE<(2009-01-23 -10);
Please clarify how to export a date format correctly and use it in MLOAD USING ACCEPT OPTION.
3 REPLIES
Enthusiast

Re: Multiload Accept Error

Is there nobody in this forum who can help me out?
Teradata Employee

Re: Multiload Accept Error


do you want to try

DELETE FROM TABLE B WHERE CURRENT_DATE<(&DELDTE - 10);

or

DELETE FROM TABLE B WHERE CURRENT_DATE<(&DELDTE.-10);

Enthusiast

Re: Multiload Accept Error

Hi
All i want is to export a date in format'YYYY-MM-DD'
And use it in ACCEPT command
Problem is that it is taking 2009-12-31 as three separate fileds....
I hope it clarifies your query....