Archives of the TeradataForum
Message Posted: Mon, 25 Aug 2015 @ 01:04:58 GMT
<-- Anonymously Posted: Monday, August 24, 2015 19:37 -->
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;
*** 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|