Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2004 @ 13:53:19 GMT

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

The rules for when you can use USING and a host variable are a little complicated, but they basically boil down to these: (1) you can only use a host variable in a place where you could use a literal, and (2) the parser must be able to determine the internal ID's for all databases, tables, etc., *before* substitution so that it can generate plastic steps. The above statement violates both rules.

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