Archives of the TeradataForum

Message Posted: Fri, 02 Aug 2002 @ 18:33:23 GMT

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

Adam,

I had the same question a few months back and successfully employed Dave's advice from his response. Basically, create a DOS script for all your utilities that first concatenates your logon script and load script into a new file. Then execute the utility on the new script. Finally delete the new script. Place the logon script in a secure directory that you can apply user level permissions for controlled access. The only risk with this is that the new file is available for view from creation to delete time in whatever directory it is in. It just depends on how long your jobs are whether this is acceptable or not.

An example script is:

COPY /A G:\Secure\FLD_LOGON.txt+G:\AB\FLD_FILE.ctl
G:\AB\FINAL_FLD_FILE.txt /V
fastload G:\AB\LOG_FINAL_FLD_FILE.txt
DEL G:\AB\FINAL_FLD_FILE.txt

God Luck,

Jason

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