Archives of the TeradataForum

Message Posted: Mon, 02 Nov 2009 @ 14:45:28 GMT

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

If you need to issue many similar statements like this you might find it easier to use Import mode in SQL Assistant.

Just issue the Query:

     MODIFY USER ? AS DEFAULT CHARACTER SET UNICODE

and point it to a file containing the usernames that you need to change.

Unlike real parameters used by other applications SQL Assistant allows you to use parameters for object names. (In DDL statements)

Mike Dempsey
Teradata Client Tools

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