delete script always delete 0 records

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

delete script always delete 0 records

Hi All,

 

Can anyone check why delete script always delete 0 records although records are there .

 

 

 

.LOGTABLE Database.dwlogtable;
.LOGON IP/username/password
DATABASE Database;

 


.BEGIN Delete MLOAD TABLES Database.Conversion;


.LAYOUT ConversionDeleteLayout;

.FIELD "Country" * Varchar(20);
.FIELD "Brand/Therapy" * Varchar(500);
.FIELD "GeoSegmentation Region" * Varchar(500);
.FIELD "Unique Visitors" * Varchar(20);
.FIELD "Date" * Varchar(10);
.FIELD "Sheet name" * Varchar(30);
.FIELD "user segment" * Varchar(30);
.FIELD "Data Segment" * Varchar(30);
.FIELD "Time Period" * Varchar(100);


Delete from Database.Conversion Where "Country"=:Country and "Date"=:"Date";
.IMPORT INFILE 'Y:\Conversion.txt'
format vartext '|'
LAYOUT ConversionDeleteLayout;

.End Mload;


.BEGIN IMPORT MLOAD
TABLES Database.Conversion;
.LAYOUT custlayout;

.FIELD "Country" * Varchar(20);
.FIELD "Brand/Therapy" * Varchar(500);
.FIELD "GeoSegmentation Region" * Varchar(500);
.FIELD "Unique Visitors" * Varchar(20);
.FIELD "Date" * Varchar(10);
.FIELD "Sheet name" * Varchar(30);
.FIELD "user segment" * Varchar(30);
.FIELD "Data Segment" * Varchar(30);
.FIELD "Time Period" * Varchar(100);

.DML LABEL lblConversion;
INSERT INTO Database.Conversion.*;
.IMPORT INFILE 'Y:\Conversion.txt'
format vartext '|'
LAYOUT custlayout
apply lblConversion;
.End Mload;

.LOGOFF;

 

 

Thanks,

Anuj Kumar

1 REPLY

Re: delete script always delete 0 records

Can you please post some sample values from the txt file.