Archives of the TeradataForum

Message Posted: Wed, 25 Oct 2006 @ 14:42:48 GMT

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

Hi Dieter Noeth AND Michael Larkins...

First of all thank you very much for you reply ...

What we are doing in the load macro is a given below...

     LOAD1 macro:
     INSERT INTO TABLE 1
     Select column1, column2 from T1...
     Where SRC1=:in_test

     LOAD2 macro:
     INSERT INTO TABLE2
     Select column2, column3 from T1...
     Where SRC1=:in_test

     LOAD3 macro:
     INSERT INTO TABLE3
     Select column3, column4 from T1...
     Where SRC1=:in_test

And so on,

The changes in other macro are the columns that are in the select statement. But if you see in the select statement the table name is same i.e. table T1.

Also explain EXEC LOAD_TEST_MACRO ('CRDW'); I didn't find any thing that say that this all the macro will run in parallel...

Hope I was clear in explaining..

Thank you,

Regards,

Amar Shetty.

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