Archives of the TeradataForum

Message Posted: Wed, 01 Oct 2003 @ 22:07:44 GMT

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

You can also have the table name as a parameter to the shell and then call the shell with the appropriate table name:

-------------------------
/* shell named createTable, needs 1 parameter: tablename */
if [ $# -ne 1 ]
then
    echo ....
    exit 1
fi

bteq << EOF
.logon teradata/${TTID},${TTPSWD};

CREATE MULTISET TABLE $1 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
          NO AFTER JOURNAL
               (

/* */
--------------------------------

$ createTable dssbatch.craig_test

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