Archives of the TeradataForum
Message Posted: Sat, 03 Sep 2016 @ 09:43:34 GMT
I'm looking for a solution to release Mload lock automatically before re running the Informatica job after failure.
Currently I'm using Informatica TPT connection to load data into a Teradata table using Mload type.
I added one pre sql command before loading into a table, it works fine if the table has Mload lock. But the command fails if table is not in Mload Status "RELEASE Failed. 2580: MLoad not active on table"
RELEASE MLOAD db_name.table_name IN APPLY
Trying to find the solution to ignore error message and execute Mload release command, so that the job does not fail even though the table is not in Mload status.
Any thoughts !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|