Archives of the TeradataForum

Message Posted: Thu, 07 Dec 2000 @ 20:54:53 GMT

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

Based upon the value in activitycount within BTEQ You could set the BTEQ return code to a known value to continue looping and then use the UNIX shell scripting to loop while the returned value is this known value. This works if the return code you set is < 255. Be careful with very low numbers or 255 as they mean something to most UNIX programmers.

Thanks,

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
NCR Corp.

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