MLOAD - UTILITY WORK TABLES

Teradata Applications

MLOAD - UTILITY WORK TABLES

Hello,

While  loading an empty table using MLOAD utility and in script work table is not mentioned then will it create a work table automatically or not  (considering table is empty).

 

1 REPLY
Senior Apprentice

Re: MLOAD - UTILITY WORK TABLES

Simply try it.
Of course the Work table(s) are created, but Work & Error tables names are optional, defaulting to

targettable_UV
targettable_ET
targettable_WT