Archives of the TeradataForum

Message Posted: Wed, 01 Sep 2004 @ 07:58:46 GMT

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

Hi,

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 ?

-Karthik

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