Archives of the TeradataForum

Message Posted: Fri, 11 Aug 2000 @ 09:06:50 GMT

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

Charles,

To remove the blank in the users account string you will need to modify that user. you can run a query against DBC.Accountinfo to find all the users that have a blank in their accountstring such as

select * from dbc.accountinfo where accountname like '% %';

This should give you anything that has a blank space in it.

To modify the user you will need to use the id that created the user and issue the following command

modify user as account = ('<place_modified_account_string_here>');

and that should be all there is to it.

Bill Grenwelge
Wal-Mart Stores, Inc.

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