Tags for ansi
SQL Warning 5815 Function is not ANSI
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.
bteq SESSION TRANSACTION ansi SESSION SQLFLAG ENTRY cast
Can we restrict/filter sessions based on session mode ?
Hi, Is there any way to restrict ANSI sessions using viewpoint/TASM ? I don't want to allow ANSI sessions into system. How can I achieve this via viewpoint or TASM or any other method ? Kindly provide your suggestions. Thanks.  
ansi filter session mode
Problem with ANSI TIME type and ODBC driver
Hi guys, I have a problem with TIME datatype and my ODBC drivers. In ODBC driver I have DateTimeFormat=III and enabled DisableParsing. When I try to run this query: INSERT INTO  aidar.time_ansi  ( "ID_1","COL_1","COL_2" ) SELECT      last_key_1,     (     CASE
time cast as time ansi
Problem with ANSI TIME type and ODBC driver
Hi guys, I have a problem with TIME datatype and my ODBC drivers. In ODBC driver I have DateTimeFormat=III and enabled DisableParsing. When I try to run this query: INSERT INTO  aidar.time_ansi  ( "ID_1","COL_1","COL_2" ) SELECT      last_key_1,     (     CASE
time ansi cast as time
JDBC connection through JAVA throwing an error, "Could not create connection; - nested throwable:"
Hi everyone, We're trying to connect to our teradata database through Java using TMODE=ANSI, and it's throwing the following error:
java jdbc ansi
Can ANSI transaction mode be set in TPT script?
Hello,
create table tpt oracle ansi casespecific tbuild transaction mode
Using INTERVAL to Add or Subtract Fractional Seconds to or from TIMESTAMP Values
Problem: How do you add or subtract a "fractional second" to a TIMESTAMP column in Teradata? The available documentation is not very clear, so let's look into it using examples. Basic use of INTERVAL Build, Populate, and Query Test Table
timestamp sql ansi interval
ANSI Mode in SQL Assistant
Hi Fellow Teradata Developer, I have a question on how to set Ansi mode on Teradata SQL assistant, I hope you can Shed some light on this. When I'm working on BTEQ, on the same Database, I run the command .SET TRANSACTION MODE ANSI, and everything seems to work properly. So It's not an issue related with the Database.
sql assistant ansi commit rollback