Archives of the TeradataForum

Message Posted: Wed, 16 Jul 2003 @ 12:38:20 GMT

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

The activitycount is a representation of rows returned to BTEQ not the contents of the result set. Try this.

Sel * from pdata.item_master sample 1;
.if activitycount = 0 then .quit 8

Rob Bankston
Teradata Certified Professional
UnumProvident - Data Warehouse

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