Add categories to log summery

[Ditza]

Hi,

I want to add special notes e.g. "MERGE statement has more than one data set with repeats of BY values"

as separate category at log summery

Does there is option to do that?

[CaseySmith]

Hi @Ditza,

The Log Summary currently only summarizes errors, warnings, and notes.  (It does not support custom categories.)  However, you can generate your own errors, warnings, or notes with code such as:

%put NOTE: MERGE statement has more than one data set with repeats of BY values;

%put WARNING: MERGE statement has more than one data set with repeats of BY values;

%put ERROR: MERGE statement has more than one data set with repeats of BY values;

Resulting in:

Casey

[Ditza]

Hi,

Thank for your answer.

To do what you said I guess I need to write the log to file and scan it to search for those errors.

Dose there is a simply why?