Questions tagged [teradatasql]

The tag has no usage guidance, but it has a tag wiki.

0votes
0answers
20views

Teradata - Which approach is faster for larger tables, update or delete and insert

I have a very large table in Teradata. I have to run a UDF on a column and store the output of the UDF back in to the column. We can do it in two ways do a direct update of that column using the ...
0votes
0answers
27views

Teradata Arithmetic operations

In Teradata when computing a percentage (see example below), I get 0 as an answer because Terada rounds results based on the number of decimal places the number have. to my knowledge I have found 2 ...
0votes
1answer
26views

Teradata - last three business day transactions ( that accounts for weekend and public holidays)

There is a transaction table tran_details that has a transaction date and there is calender table calender_days that has flag against all dates if a particular day is a business day or not. I have ...
0votes
1answer
20views

how to use case when to create a new column in table B to show if data from table A also in table B

When I try following code it returns attached error code select acct_key, (case when acct_key in ( select acct_key from table_A ...
1vote
2answers
41views

how to take rows after a certain criteria SQL

I am using Teradata SQL and have the following data: ID MonthID Acc Complaint 1 202202 5 1 1 202203 4 2 1 202204 3 0 2 202202 2 0 2 202203 3 1 2 202204 2 3 3 202202 1 0 3 202203 2 0 3 202204 ...
-2votes
2answers
46views

Filter unwanted characters from a column in Teradata

I have a Phone number column in my table with values only being numbers and no special characters. for one of the column I got a value coming in as ":1212121212". I will need to filter this ...
0votes
0answers
19views

TERADATA DEADLOCK

Can anyone help me out to find out values of following flags in Teradata system. 1)deadlock.retry.enabled 2)deadlock.retry.interval 3)deadlock.retry.maxAttempts Thanks in advance.
0votes
0answers
41views

3706: Syntax error: expected something between '=' and the 'BETWEEN' keyword TERADATA Database

I've been trying to create an ApplySimple and i keep getting this error but i dont know what is wrong with it. ApplySimple("CASE WHEN #0= BETWEEN '0' AND ' 5' THEN '0 a 5' WHEN #0= ...
0votes
0answers
28views

Pull a timelines by product by instance into 1 row instead of many

I'm trying to pull the timeline for each function into 1 line for each car. The car started in the factory, Function - Start Date - End Date - Person the frame was built on 05/23/2022 04:16 AM 05/23/...
0votes
0answers
33views

teradata gaps between previous date and preceding date by date by employee

I want to get the gap time between records and make that a row. first record Joe StartDate 5/23/21 8:46 AM EndDate 5/23/21 9 AM, next record Joe start date 5/23/21 9:23 AM End Date 5/23/21 10:43 AM, ...
0votes
0answers
36views

Teradata SQL Assistant import data with commas

I was following instructions with teradata sql assistant in order to import a CSV file into teradata with the following command: Everything seems to work fine except that the dataset contains strings ...
  • 182
0votes
0answers
21views

No remaining space in Teradata Database

I created a database of storage 18 gb using: CREATE DATABASE demo FROM DBC AS PERM = 18000000000, -- 18GB SPOOL = 15000000000; -- 15GB NO FALLBACK NO BEFORE JOURNAL NO AFTER JOURNAL; I need to load ...
  • 45
0votes
0answers
21views

split int col in Teradata

I was trying to split int column in Teradata but its showing error *** Failure 9134 Unsupported type detected. SELECT col1,strtok(col2,0 ,1) FROM table;
0votes
1answer
37views

Teradata : Extract Date from string

There is a notation field with different number of characters. Eg Exceed Limit Fee 26-January-2020 or Account Exceed Limit Fee 05-June-2001 I want to extract date part of it and convert that to date ...
1vote
1answer
22views

number pattern matching in Teradata

I was trying to get the rows matched with a pattern by using like in Teradata select * from table_name where col_name like '10%'; here I wanted to get all the rows with column values like 1000, 101, ...

153050per page