Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 16 Mar 2009 @ 20:13:50 GMT

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

Subj:   Re: BTEQ question: How to handle login/password
From:   Hopkinson, Zachary

If you're worried about others reading it in Unix then have each user create a hidden file under their home directory. ".tdlogon" seems to be pretty standard here. Then in your script you can do something like (Korn shell here, but I don't see why it wouldn't work elsewhere) Another alternative I see some people using is ftppwd but I really don't care for that method.

(As mentioned earlier in this thread .tdlogon would contain your logon command: ".logon dbcname/username,password;")

     HOME_DIR=`echo ~`
     export TDLOGON="${HOME_DIR}/.tdlogon"

     bteq << EOF
     .run FILE=${TDLOGON}

     /* Commands */


  <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: 27 Dec 2016