Strange error message while running BTEQ update statement.

Tools & Utilities
Enthusiast

Strange error message while running BTEQ update statement.

Hello Masters,

One of my users is having a strange error   while running BTEQ   update statement. Below is the description of the issue:

User is bringing data from SQL server (source)    to the teradata staging database. . But there are some Unicode characters in the SQL server (source) side.

The user   is trying to implement Incremental loading from the    staging   database to   destination (EDW database).  To do this he is in the process of testing the bteq code.

The bteq code he is testing is working fine for most of the tables but for some tables he is getting some strange errors.

While doing the initial load from staging database to EDW database it is working fine but while testing the update for incremental loads then he is facing below issues for some tables.

BREAK received. Input Command:

 *** Warning: Abort command not received after the BREAK.

              Returning to normal mode.

BREAK received. Input Command:

 *** Warning: Exiting because of error reading BREAK command.

 *** Exiting BTEQ...

 *** RC (return code) = 2

Do you have any idea in what situation we get this error?   Do you think update is failing due to   any unicode special characters in data?

Any help will be appreciated.