 |
 |
Archives of the TeradataForum
Message Posted: Thu, 27 May 2004 @ 12:48:51 GMT
| 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.
| |
