Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 08 Oct 2008 @ 08:21:42 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020