Archives of the TeradataForum

Message Posted: Fri, 10 Aug 2007 @ 17:39:31 GMT

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

<-- Anonymously Posted: Friday, August 10, 2007 11:33 -->

In UNIX, you can use "here documents" that allow replacing shell variables in the script

In Windows, use Cygwin and do the same :-)

Example script below needs 2 parameters: Database name and table name Generates output file <DBname>.<Tablename>.out:

     ------------------------
     #!/bin/ksh
     if [ $# -ne 2 ]
     then
        echo "Usage: $0  "
        exit 2
     fi

     bteq <

 
 
 
 


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