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.
This might be out of context but I have a small question, does .ACCEPT take 0 as well i.e if we have 010 in the file does it take 010 or only 10.....? Is there a way to make it take 010 as input using a file....?