Top "Teradata" questions

how do i filter out non-numeric values in a text field in teradata?

oI have a teradata table with about 10 million records in it, that stores a numeric id field as a varchar. …

sql types filtering teradata

How to generate AUTOMATIC Number in Teradata SQL

I want to generate AUTOMATIC Number to use TD SQL, for example as follows, CREATE MULTISET TABLE TEST_TABLE ( AUTO_…

sql auto-increment teradata

Insert Multiple Rows SQL Teradata

I am creating a volatile table and trying to insert rows to the table. I can upload one row like …

sql teradata sql-insert

Difference between timestamp(0) and timestamp(6)

Can some body tell me the difference between timestamp(0) and timestamp(6) in Teradata

timestamp teradata

Connecting Java and Teradata: The UserId, Password or Account is invalid

I have been trying to connect to Teradata Class.forName("com.teradata.jdbc.TeraDriver"); String connectionString = "jdbc:teradata://xxx.xxxxxx.…

java teradata

Teradata equivalent for lead and lag function of oracle

I have been working ot see the equivalent function for Oracle lead and lag function. The oracle lead would look …

sql oracle lag teradata lead

Explain Query Bands in Teradata

Can anyone explain Query Bands in Teradata? I've searched regarding this a lot, but wasnt able to get information which …

teradata

How to find all the tables in database Teradata with specific column names in them?

I have 2-3 different column names that I want to look up in the entire DB and list out all …

sql database teradata

Create Teradata volatile table and select from table using isql

I am trying to submit a two-statement SQL file as a batch job to the isql utility on a Linux …

teradata isql ddl

Get column type using teradata system tables

I want to get the actual column type from teradata system tables like dbc.columns. This table have column columntype …

sql metadata teradata