Home Page for the TeradataForum

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020