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.
*** 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.