All Forums General
karthik_2244 36 posts Joined 12/10
01 Jul 2011
source as table in utilities?

Is it possible to load a tableB from a tableA in td using utilities Mload/TPUMP?

ex: insert into tableB sel * from TableA.

Jimm 298 posts Joined 09/07
01 Jul 2011

Why on earth would you want to!

You would have to export the data to a flat file. If you really need to, export tableA as IndicData.
TPT can do it directly, but it is still mich faster to do a straight Insert/ Select.

dnoeth 4628 posts Joined 11/04
01 Jul 2011

Of course it's possible as part of the job preparation/cleanup.

Before the BEGIN MLOAD and after the END MLOAD you can use almost any SLQ statement.

Dieter

Dieter

karthik_2244 36 posts Joined 12/10
01 Jul 2011

Thanks Dieter and Jimm

You must sign in to leave a comment.