Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Surrogates through Mload
From:   Kamin Shah


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.


     .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);


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


Kamin Shah

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023