Column gets truncated and gets inserted

Tools

Column gets truncated and gets inserted

We are trying to insert records from a flat file to a table in Teradata.
There is a field whose length is 52 characters in flat file and 50 characters in Table. When the field gets inserted it removes the last 2 characters and inserts that record. Ideally the record should be rejected.

Any information about how is happens will be helpful for us.
2 REPLIES
Enthusiast

Re: Column gets truncated and gets inserted

I don't think, character columns return an error, if there is an overflow...
Enthusiast

Re: Column gets truncated and gets inserted

If you execute the request in ANSI session mode, truncation will raise an error condition. In "BTET" mode, truncation is accepted without raising an error.