Archives of the TeradataForum

Message Posted: Fri, 20 Jan 2012 @ 10:54:07 GMT

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

At some point you will have to make a distinction.

How does this command:

     LOGON ${LOGON};

Know that it should user A and this one:

     LOGON ${LOGON};

Know that it should user B? Obviously it cannot unless you tell it somehow.

At some point you will have to have something like this:

     LOGON=userA,passwordA

Or

     LOGON=userB,passwordB

Or something like this:

     LOGON=`readCredentialsFromSomeDataSource userid=userA` Or
     LOGON=`readCredentialsFromSomeDataSource userid=userB`

The alternative is you could accept the user credentials from a command line with something like this (assuming a shell script):

     USER=$1
     PWD=$2
     LOGON=$USER,$PWD

Then when you run the process you can supply the use and password as command line parameters.

Of course you could make this as sophisticated or simple as you desire and/or your scripting skills permit.

Good luck

Glenn Mc

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