We are using Informatica TPT mload to load data to Table. I understand If the mload fails we need to "release mload lock on table".
I understand "release mload" command can be invoked only from BTEQ mode and its not working if use the "release mload" command in pre/post SQL that has TPT mload connections.
Is there any way that we can release mload using Informatica, if so , pls let me know how
I'm trying to write a Stored Procedure with RELEASE MLOAD statement, like that:
CREATE PROCEDURE DWH_STAGE.PRC_RELEASES()
RELEASE MLOAD DWH_DATA.ACCESS_DEVICE_FEATURE IN APPLY;
When I execute that script there is an error: "SPL1027:E(L3), Missing/Invalid SQL statement'E(3706):Syntax error: expected something between the 'RELEASE' keyword and the 'MLOAD' keyword.'."
Can you help me to find out the way to introduce into a stored procedure a RELEASE MLOAD statement?.
Thanks for your colaboration.
RELEASE MLOAD is a Teradata SQL statement that is recognized by BTEQ and Teradata MultiLoad, hence it might not be supported in SP.