Going mad with the record going to UV table

Database
Enthusiast

Going mad with the record going to UV table

Dear All,

This is very simple script that i have written but doesnt seem to be working for some weird reason. The record is going straight to into the UV error table. The suprising fact is that there is only one record in the source file and the target table is empty.

The record looks like the one below with 3 fields empno,ename and deptno.

10021Trevor10

MLOAD SCRIPT....

.logtable financial.inslogtable;

.logon 192.168.153.128/dbc,dbc;

CREATE TABLE financial.employee (

EmpNo SMALLINT FORMAT '9(5)' BETWEEN 10001 AND 32001 NOT NULL,

Ename varchar(30) not null,

Deptno number not null

)

UNIQUE PRIMARY INDEX( EmpNo );

.begin import mload tables financial.employee;

.layout inslayout;

.field EmpNo 1 char(4);

.field ename 6 char(6);

.field deptno 12 char(2);

.dml label insdml;

insert into financial.employee.*;

.import infile C:\TeradataDataFiles\insert.input.txt

format text

layout inslayout

apply insdml;

.end mload;

.logoff;

Regards

Suresh

1 REPLY
Junior Contributor

Re: Going mad with the record going to UV table

When you check the data in the UV table you should find an empno 1002, which clearly fails the BETWEEN check :-)

.field EmpNo 1 char(4);  

Dieter