i want to make my session fail when ever encountered data Truncation.
current scenario in my session i am using Teradata TPT script to load data from source to target.
sometime due to datalength mismatch data truncate getting load to target without throwing the error.
EX : souce is VARCHAR(15) and target VARCHAR(10) in this scenario my session is throwing warning only and internally it trim and truncate rest 5 character. and first 10 char load in to target.i want to make my session to fail if any truncation occur.
as of now through googling i tried two otpion
1) Reject Truncated/Overflowed rows i checked in this target proerty
2) Stop on errors i did set to 1
but still it doesn't solve the probllem.please suggest any other way make it achieve.