Archives of the TeradataForum

Message Posted: Fri, 20 Jan 2012 @ 10:52:30 GMT

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

Hi,

If you've got CLIv2 from TTU14 then you can probably use TDWallet to do this.

With that software installed (and the entries added to TDWallet) your logon string can be coded as:

     .logon TDSYSTEM1/$tdwallet(user_for_$(tdpid)),
     $tdwallet(password_for_$(tdpid));

The TDWallet software will extract the username and password for TDSYSTEM1 and insert them back into the logon string which then gets passed to the Teradata system.

This example basis things around the tdpid but it does mean that you do not hard-code usernames and passwords in script files.

Does that do what you want?

If you haven't got TTU14 installed then you cannot do this using Teradata software, you have to use a 'non Teradata' approach, something like shell script processing.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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