Archives of the TeradataForum

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

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

<-- 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>>