Monday, March 21, 2011

Password Variables

#! /usr/bin/ksh

echo "#------------------------------------------------------------------------------"
echo "# get passwords for the ftp and for sqlplus and assign to variables."
echo "#------------------------------------------------------------------------------"

export FTP_PASS='cat /ux123/dfact/xlt/scripts/ust_grp.password'

export SQL_PASS='cat /ux123/dfact/xlt/scripts/xlt_ods_uat.password'

echo "#------------------------------------------------------------------------------"
echo "# start ftp from vax --i: turn off prompting    n: turn off login"
echo "#------------------------------------------------------------------------------"

ftp -in host1 <
quote user ust_grp
quote pass $FTP_PASS
...
quit
EOF

echo "#------------------------------------------------------------------------------"
echo "# In SQL+, ...
echo "#------------------------------------------------------------------------------"

sqlplus -s  $SQL_PASS << EOF
.
.
exit;
EOF

No comments:

Post a Comment