Archives of the TeradataForum

Message Posted: Tue, 16 Oct 2007 @ 16:05:14 GMT


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

Subj:		Surrogates through Mload

From:		Kamin Shah

All,

I am trying to load a surrogate key column through Mload. Any ideas of how I could do it? Or is it even possible? Ideally I want to use row_number() to generate surrogates. I tried using row_number but it is giving me an unrelated error. Here is the script and the error I am getting.

     ***Script*****

     .dml label insdml;

     insert into database.test (c1,c2,c3,c4)

     values(row_number() over(order by :c2,:c3),:c2,:c3,:c4);

     .layout inplyt;

     .field c2 * varchar(100);

     .field c3 * varchar(100);

     .field c4 * varchar(100);

     ***Error*

           **** 11:57:33 UTY0805 RDBMS failure, 3521: Table reference(s)
                detected where constants  expected.

Thanks

Kamin Shah