Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 May 2004 @ 12:48:51 GMT


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


Subj:   Re: Problem in using Import command in BTEQ
 
From:   Geoffrey Rommel

  I have to Import two datasets (mainframes). Dataset 1 has fields a, b and Dataset 2 has fields c, d.  


  Now my problem is that I have to compare field ( from datasets) 'a' with field 'c' inside this BTEQ script and check that a > c.  



How could BTEQ know which records from the two data sets correspond? According to the above, the two data sets have no common fields. I think you will have to run a separate step to stick the records together before running BTEQ. You need not write a compiled program to do this; Quikjob could handle it easily.



     
  <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: 23 Jun 2019