Archives of the TeradataForum

Message Posted: Wed, 22 Jan 2003 @ 19:54:53 GMT

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

Craig,

In our batch environment, we create a secured dataset with the logon id and password and put the dataset in the JCL to execute BTEQ without hard cording every time.

//SYSIN    DD DSN=JOBid.TEST.BTEQ(LOGONID),DISP=SHR
//         DD DSN=JOBid.TEST.BTEQ(BTSCRIPT),DISP=SHR
//         DD DSN=JOBid.TEST.BTEQ(LOGOFF),DISP=SHR

JOBid.TEST.BTEQ(LOGONID) looks like -

.LOGON P/userid,password;

JOBid.TEST.BTEQ(LOGOFF) looks like -

.LOGOFF;

Hope this will help.

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