Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2003 @ 23:23:40 GMT

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

I UNIX, you can use environment variables to specify the database and or the table name.

We use profiles that set environment variables for different platforms. Dev, Test, and production. That way we don't hard code and database names. I hope this helps.

Here are a few sections from a shell script.

. ${DW_SBIN}/prof.dw.sh # Execute application profile

...............
...........
.............

bteq < .run file ${Logon_monthly}
.if errorcode <> 0 then .quit 16 ;
.os rm ${ExpDir}${ExpFile}
.retry off
.export report file = ${ExpDir}${ExpFile}
.width 250
database ${DBName} ;
.if errorcode <> 0 then .quit 17 ;

Select

Wayne N. Moran

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