source as table in utilities?

General
Enthusiast

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.
3 REPLIES
Enthusiast

Re: source as table in utilities?

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.
Junior Contributor

Re: source as table in utilities?

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
Enthusiast

Re: source as table in utilities?

Thanks Dieter and Jimm