Archives of the TeradataForum
Message Posted: Wed, 26 May 2004 @ 13:36:37 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|