Archives of the TeradataForum
Message Posted: Fri, 23 Feb 2001 @ 15:14:50 GMT
I am having problems with a MLOAD DELETE script which I am creating for a purge job. This job will run monthly and delete data off 6 - 8 million rows of a 500 million row table each time. I am using a Mload Delete task with a single record input file which has the date for purging the events. According to the Mload reference I can use a single imported data record in a Delete Mload by defining Layout, Field, Import statements.
The error message I am getting is
"10:15:46,UTY0805 RDBMS failure, 2550: MLoad error: bad internal status - Delete Mload Started while Import Mload suspended".
The Mload script looks like follows:
.LOGTABLE Log_tbl1; .RUN FILE LOGIN; .BEGIN DELETE MLOAD TABLES Tbl1 WORKTABLES WT_Tbl ERRORTABLES Err_Tbl ; .LAYOUT Layout1; .FIELD PURGE_DT * DATE; DELETE FROM Tbl1 WHERE CAST(EVENT_TS_EST AS DATE) >= :PURGE_DT ; .IMPORT INFILE DATAIN LAYOUT Layout1;
I appreciate any help in this regard.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|