Archives of the TeradataForum

Message Posted: Wed, 22 Jan 2003 @ 19:52:44 GMT


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

Subj:		Re: BTEQ logon

From:		John Adams

From: Craig Windland

How do you log on to BTEQ without hard coding the logon text into every script. I want to create one file containing the authentication information that is used by all scripts in a batch environment. So far I have had no success.

What we do (under UNIX) is protect a directory and put one-liner run files for each logon, like:

.logon dbc/ourid,password

Then we put a .run file=/protected/directory/ourid.btq statement in the scripts.

If you make the names of the logon files correspond to the ID, it's easier to administer--we use the C preprocessor to sub in values, but you may find a Perl script or a shell script more congenial in your environment.

Does this help?

John A