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
SESSION SQLFLAG was set to
ENTRY. Both were configured intentionally.
CAST(SALARY_AMOUNT AS INTEGER)
*** Query completed. 40 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
*** SQL Warning 5815 Function is not ANSI.
Thank you in advance for any response.
CAST is no SQL92 entry level:
2) The following restrictions apply for Entry SQL in addition to any Intermediate SQL restrictions:
a) Conforming Entry SQL language shall not contain any <cast
Thanks, Dieter. May I know the reference of this information? I just browsed Wikipedia and it was mentioned that CAST is included in SQL-92 ANSI standard. CAST was also mentioned to be included in SQL-92 from the reference, "ODBC Driver for Teradata User Guide" (page 98).
Link to Wikipedia:
Flagging SQL compliance was a SQL-92 feature, CAST is Standard SQL, but not in Entry Level.
A copy of SQL-92 can be found at: