Archives of the TeradataForum

Message Posted: Wed, 10 May 2006 @ 13:33:39 GMT

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

In SQL Assistant you can used a named parameter - a '?' followed by a word.

For example, if the value is a character string:

        where datemes='?dat'
     or where datemes=('&' or  ':' or '?dat') datemes
     in your example.

Then SQL Assistant will prompt you to enter a value for 'dat' whenever you submit the query.

Named Parameters are directly inserted into the SQL - they are not 'true' parameters, so the quotes around the parameter are required if the value is a string.

Mike Dempsey
Teradata Client Tools

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