Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2003 @ 21:59:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Fastload or bteq, your second row will bounce unless you specify 'cs' (case specificity) on COL1. I built the following script, just to check myself.

database equitree;

drop table eds_cs;
ct eds_cs (

 COL1 CHAR(3)  NOT NULL
,COL2 SMALLINT NOT NULL
,COL3 VARCHAR(80) NULL )
unique primary index (COL1,COL2)

ins eds_cs values('AAA',     100    , 'sample data row 1 ');
ins eds_cs values('aaa',     100   ,  'sample data row 2 ');  <-- fails

/* the following works fine */

drop table eds_cs;
ct eds_cs (

 COL1 CHAR(3) cs NOT NULL
,COL2 SMALLINT NOT NULL
,COL3 VARCHAR(80) NULL )
unique primary index (COL1,COL2)

ins eds_cs values('AAA',     100    , 'sample data row 1 ');
ins eds_cs values('aaa',     100   ,  'sample data row 2 '); <-- wont
fail

--
Dwight Etheridge
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>