Archives of the TeradataForum
Message Posted: Wed, 08 Oct 2008 @ 08:21:42 GMT
| Subj: || || Re: BTEQ Export - concatenating null values |
| From: || || Michael Larkins |
| ||*** Failure 3800 Datatype Mismatch in THEN/ELSE expression.|| |
Are you telling us that you don't know what the error is telling you?
If this is the case, it simply means that you are using either a character literal with numeric data or numeric literal with character data.
Make sure that you use character literals with char data and numeric literals with numeric data.
Certified Teradata Master
Certified Teradata SQL Instructor