Archives of the TeradataForum

Message Posted: Thu, 01 Oct 2009 @ 13:05:36 GMT

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

In SQL Assistant you can use a parameter marker (like ?MyTable) to replace anything you want.

These are not true 'parameterized' queries from the database point of view. SQL Assistant simply replaces the parameter marker with whatever string you enter, before submitting the query to the database.

This means that you can use a parameter to replace Table, Database and Column names as well as data values.

Johannes is correct in saying that if you were using BTEQ (for example) to submit true parameterized queries to the database you would not be able to use a parameter in place of an object name.

Mike Dempsey
Teradata Client Tools

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