Archives of the TeradataForum
Message Posted: Fri, 06 Feb 2004 @ 13:53:19 GMT
| Subj: || || Re: BTEQ Import, Variable Substitution Error |
| From: || || Geoffrey Rommel |
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.