Stop Job on no value

[EGuarato1648206044]

Hello, I want to put some restriction and stop the process in case of no value. (not null value).

So i want to check:

1) if a quey in the component t_DBInput doesn't return anything -> t_Die, else goes on.

2) if a t_FileFetch can't get the file -> t_Die else goes on.

I tried to use the t_SchemaComplianceCheck but it seems checking on Null value, not on no value at all. Or maybe the component is the right one but i'm using it in the wrong way.

[Anonymous]

Hi

For 1), there is a global variable that counts the total number of records are returned, you can use this variable as condition, eg:

tDBInput--tJavaRow( or other components)---runIf--tDie

set the condition of runIf as:

((Integer)globalMap.get("tDBInput_1_NB_LINE"))==0

For 2), just check the 'die on error' box? does the component has an error if no file is fetched?

Regards

Shong

[gjeremy1617088143]

Hi, for tSchemaComplianceCheck you have an option in advanced settings of the component named Treat all empty string as NULL,

if you check this one and set a non null column then the component will reject null value and empty value for a String.