Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 May 2004 @ 13:36:37 GMT


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


Subj:   Problem in using Import command in BTEQ
 
From:   R.Lakshman

Hi

We are using BTEQ in Mainframe environment,

In BTEQ script there is an IMPORT command. Using this command we can import datafiles/datasets to BTEQ environment.

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 can we do this ?

I would appreciate if anybody can put a sample code for this.


Thanks in advance for your help

Neena



     
  <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