|
Archives of the TeradataForumMessage Posted: Fri, 23 Feb 2001 @ 15:14:50 GMT
Hi, 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. Thanks, Ramesh
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||