Archives of the TeradataForum
Message Posted: Tue, 16 Oct 2007 @ 16:05:14 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|