Making a DI Studio job fail when the input table is empty

[ENM]

DI Studio question. I want to make sure that if an input table is empty, the job fails (triggers an ERROR) and stops running. How can this be accomplished?

P.S. Should be resolved without user written code.

Thanks for your time.

[Patrick]

If you want full control then I believe you would have to implement this either as pre-code in the node or as a custom transformation.

You could create a autocall macro for this and then simply call this autocall macro. Some nodes generate a macro "%etls_recordCheck" which could serve as a starting point to write such a macro.

[BrunoMueller · Accepted solution]

SAS Data Integration Studio can be extended with your own user written transformations, so you would need to code it once and then just use it again and again. The code for such a transformation could look like this:

%macro myCheckData;
  %global trans_rc;

  data _A_%sysfunc( compress(&transformID, .));
    set &_input(obs=1);
  run;

  %put NOTE: &=sysnobs &=syserr;

  %if &sysnobs = 1 %then %do;
    %let trans_rc = 0;
    %put NOTE: OKOKOKOKOK;
  %end;
  %else %do;
    %let trans_rc = 8;
    %put NOTE: NOTOK NOTOK NOTOK NOTOK;
  %end;

  %put NOTE: &sysmacroname &=trans_rc;
%mend;

%myCheckData

You can use then the normal Return Code Check transformation.