Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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


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