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.