Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 25 Aug 2015 @ 01:04:58 GMT


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


Subj:   SQL Warning 5815 Function is not ANSI
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, August 24, 2015 19:37 -->

Good day.

This warning was returned in BTEQ after executing the following query. Is there something missing with the syntax? Please note that the SESSION TRANSACTION was set to ANSI and SESSION SQLFLAG was set to ENTRY. Both were configured intentionally.

     SELECT SALARY_AMOUNT,
        CAST(SALARY_AMOUNT AS INTEGER)
     FROM EMPLOYEE;

Message Returned:

     *** Query completed. 40 rows found. 2 columns returned.
     *** Total elapsed time was 1 second.

     FROM EMPLOYEE;
     $
     *** SQL Warning 5815 Function is not ANSI.

Thank you in advance for any response.


Best regards,

Anomy



     
  <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: 15 Jun 2023