topic How to Use Context Variable on Run if Row Component in Talend Studio

How to Use Context Variable on Run if Row Component

Anonymous — Sat, 16 Nov 2024 11:28:46 GMT

Hi..
I have handle SQL Server error in stored procedure using TRY and CATCH Block.Stored Procedure gives the Error output as
ErrorMessage ,ErrorSeverity and ErrorState.All these values are stored in context variables.
On RunIf Trigger i want check condition as mentioned belowed:-
If ErrorState has no value then it should execute next sub job of extracting data from table into CSV file.
And ErrorState has value then it should not execute next sub job.
Thanks in Advance for help
Regards
Amruta Joshi

Re: How to Use Context Variable on Run if Row Component

Anonymous — Mon, 06 Oct 2014 15:47:15 GMT

Assuming that, by "no value" you mean null :-
Your two If tests are simply :-
context.ErrorState == null
context.ErrorState != null

Re: How to Use Context Variable on Run if Row Component

Anonymous — Thu, 09 Oct 2014 15:27:26 GMT

Hi..
CASE 1:-
Snippet Code:-
BEGIN CATCH
    DECLARE @ErrorMessage NVARCHAR(4000) = ERROR_MESSAGE();
    DECLARE @ErrorSeverity INT = ERROR_SEVERITY();
    DECLARE @ErrorState INT = ERROR_STATE();
END CATCH
     --Retrieves the error message along with RowId and BatchTransId where error occured
    SELECT @ErrorMessage As ErrorMessage,@ErrorSeverity As ErrorSeverity,@ErrorState As ErrorState
Then i get ErrorMessage with value as null and set in context Variable and Checks Context.ErrorMessage==null in RunIf Trigger It works fine.
But In CASE2 :-
BEGIN CATCH
    DECLARE @ErrorMessage NVARCHAR(4000) = ERROR_MESSAGE();
    DECLARE @ErrorSeverity INT = ERROR_SEVERITY();
    DECLARE @ErrorState INT = ERROR_STATE();
SELECT @ErrorMessage As ErrorMessage,@ErrorSeverity As ErrorSeverity,@ErrorState As ErrorState
END CATCH
In this Case Select statement will executed if error occurs ,but no errors occurs errorMessage will have no value.
Since Context variables are in tjava_row component
How to check the whether Context .ErrorMessage has value or not?
Thanks for ur help in advance.