Archives of the TeradataForum

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

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

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 */

     .quit;
     EOF

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