Archives of the TeradataForum
Message Posted: Wed, 01 Sep 2004 @ 07:58:46 GMT
We have two tables namely A and B.Table A has a column that stores COUNTS.
Table B contains records.Now I want to abort the job if I have the following condition
For ex: ABORT IF A.COL1 <> SELECT COUNT(*) FROM B
How can I do this using BTEQ or Macro ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|