Archives of the TeradataForum

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

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

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>>