Error limit in TPT's STREAM

Tools & Utilities
Enthusiast

Error limit in TPT's STREAM

Hi All,

I want to capture rows skipped due to Errors from STREAM operator. I see that this is not captured in STREAM in the way it is done for LOAD. I just get the following message.

STREAM_OPERATOR: Rows Inserted: 285

STREAM_OPERATOR: entering Cleanup Phase

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 286, Total Rows Sent = 0

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 0, Total Rows Sent = 286




However in Load operator, I get following message clearly indicating the rows that erred out.

LOAD_OPERATOR: Total Rows in Error Table 1:   0

LOAD_OPERATOR: Total Rows in Error Table 2:   0

LOAD_OPERATOR: Total Duplicate Rows:          0

Could you please let me know if there is such an option in STREAM operator? I'm using TTU 14.10.00.10.

1 REPLY
Teradata Employee

Re: Error limit in TPT's STREAM

Starting in 15.00, the Stream operator will output the same stats for the error table to the console output, similar to what is done for the Load and Update operators.

The information is always available in the Stream operator private log.

-- SteveF