Top "Teradata" questions

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms.

Can I query a procedure's RequestText in Teradata?

Teradata has a useful view called dbc.tables that you can use to query objects. I've used this to query …

sql stored-procedures teradata
How to set up .net teradata connection in c#?

I am trying to connect to Teradata with c#. I am using the sample code from this website using System; …

c# teradata
What is the difference between GROUP BY and DISTINCT?

I have the table with the following data empid empname deptid address -------------------------------- aa76 John 6 34567 aa75 rob 4 23456 aa71 smith 3 12345 aa74 …

sql teradata
Teradata - how to select without locking writers? (LOCKING ROW FOR ACCESS vs. LOCKING TABLE FOR ACCESS)

I am developing an application which fetches some data from a Teradata DWH. DWH developers told me to use LOCK …

teradata rowlocking table-locking
check if volatile table exists in teradata

Volatile table are great and somewhat comparable to temp tables in sql server (my background). Is there a way to …

teradata
Creating and using temporary/volatile database tables In Stata

Addendum: As of Stata 14, volatile tables work without any hacks. Is there a way to tweak Stata to work with …

sql odbc stata teradata
Teradata: how can I get the primary key and foreign key definition of a table?

The tables are already there but I don't know how they are crated. Now I want to get the definition …

sql teradata
Calculate time difference in Teradata

I have a scenario to calculate difference of timestamp in minute. There is one common field in 2 tables i.e …

datetime timestamp left-join teradata teradata-sql-assistant
split row_number() over partition over multiple columns

I have a query which uses row_number() over partition. When the result comes out it looks like Product Row_…

sql teradata row-number
How to TRANSLATE unicode to latin in Teradata?

My table contains a field lastName that is UNICODE I need to implement the SOUNDEX function, but it won't work …

unicode teradata latin