Archives of the TeradataForum

Message Posted: Fri, 23 Sep 2005 @ 10:25:58 GMT

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

You have to options.

1.You can do this by Teradata SQL Assistant (Aka Queryman). You can put your SQL scripts in query wnidow and press a button called 'EXECUTE PARALLAL'.

2.You can use a BTEQ and separate the queries by ';'. Here is the example for INSERT.

     INSERT INTO Dbase1.TABLE1
     SEL * FROM Dbase2.TABLE2
     ;INSERT INTO Dbase3.TABLE3
     SEL * FROM Dbase4.TABLE4;

For more examples, you may need to refer the Teradata Technical documentation.

Thanks

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