Error Teradata Multiload stage - Script Auto Generated

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi,

Where did you find this error? In the Director or in the report file. Always check the report file for Multiload errors.

Also when you re-start the job you have to drop all the temp tables that would be created for each multiload session like log, UV, err and work tables. Then issue the command RELEASE MLOAD <table_name>

I always load the data using Teradata API stage and if the load is successful then replace with the Teradata Multiload stage.

Also do a search, I think this was discussed earlier.

HTH
--Rich
IBM Certified DataStage Solution Developer | Teradata Certified Master
Post Reply