Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 16:59:38 GMT

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

You can use a Multi Statement Request (MSR)

In BTEQ you can submit the following

INSERT INTO TABLE_EMPTY SELECT * FROM TABLE
;INSERT INTO TABLE_EMPTY SELECT * FROM TABLE1;

This will submit the two statements in parallel into TABLE_EMPTY with no TJ. The position of semicolon on the second line is important as otherwise it request will be treated as two insert statements.

You can submit the same request in Queryman by hitting F9 to execute the request in parallel, as a MSR. (The position of the semicolon isn't important for Queryman.)

Hope this helps,

Fachtna

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