Home Page for the TeradataForum
 

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



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