All Questions

0
votes
1answer
12 views

get rid of zeros after decimal point

Hi All, select CAST(MIN(column_1) AS DECIMAL(10,2)) Days from tale_1 I get output as 13.09 13.30 31.00 Can anybody let me know how to get rid of the zero after the decimal poin …
0
votes
0answers
13 views

Retention of data in DBC.DBCAssociations

This table is used to support the migration of objects between Teradata installations using the ARCMain tools (COPY/RESTORE) and provide a mapping of the old object id's to the new …
0
votes
1answer
28 views

How to interpret value of field ‘CreateDate’ in TDWM tables?

CreateDate and RemoveDate are two fields in many of the tables related to TDWM e.g. in WlcDefs. The values and their meanings (according to me) are like: 1100301 - 2010/03/01 1091 …
0
votes
3answers
29 views

How to split one column data into multiple columns

How to split one column data into multiple columns using Teradata sql-assistant? For example: I have a table “T1” which has only one column C1 varchar (100) and it has pipe delim …
0
votes
1answer
18 views

Does RollbackPriority=TRUE mean to use Rush or No Rush for rollbacks?

This DBSControl setting is supposed to control whether rollbacks run at Rush priority or not. They used to always run at Rush because Teradata wanted to get them out of the way as …
0
votes
1answer
30 views

Teradata SQL Assistant takes forever to interrupt large answerset

I am using Teradata SQL Assistant version 13.0.0.08 on Windows. I think it's the version written in C#. When I run a query that returns more than 2000 rows, which is my max in the …
1
vote
2answers
24 views

Order by based on case sensitivity

Hello All , Is there any way to sort the column data based on case sensitivity. How can I do order by if I want to display the UPPER CASE data first of same order first and then t …
0
votes
1answer
29 views

Decode with Rownum

Hi, I have a requirement in Oracle using Decode function with Rownum. I need to convert this into Teradata. I need help in this. I tried using Top function and Rank qualify but un …
0
votes
2answers
17 views

order by issues

Hi, I need help in order by, I have a subquery which gets this data. pname version count xxx V12.1 1 yyy V22.1.3 1 We are using grouping function and roll u …
0
votes
1answer
14 views

How to yield maximum decimal digits from a cast?

I want to demonstrate the problem with the help of an example. Accurate division: 7299 / 48 = 152.0625 However, in Teradata all precision is lost when querying for select 7299/48 …
0
votes
2answers
19 views

Difference between FilePres and FilePreReads

From Teradata documentation, the definitions of these ResUsageSpma columns are: FilePres Total number of times a cylinder is loaded. FilePreReads Number of times a cy …
0
votes
1answer
14 views

How to perform Bit-wise operations in SQL?

How to perform simple bit-wise operations like OR (|), AND (&), XOR (^) in SQL queries? Can these be performed on numeric values? like sel 1 | 2;
0
votes
1answer
7 views

Blank Column title

Hi, I need help in not displaying the column title in the select list. For eg: in Oracle select 'abc' as " " from dual we get abc with blank column name In teradata we are n …
1
vote
1answer
21 views

Timestamp difference

Hi Experts, Need help here. In Oracle when we do timestamp difference. The resultset would be days and with some decimal numbers. For Eg. SELECT '03.12.2004:10:34:24' "Now", …
0
votes
2answers
49 views

6760 Invalid timestamp

Hi, I am trying to update the timestamp into a table like this: Update tablea set status = 'Succeeded', end_date = cast(cast(current_timestamp(0) as format 'dd/mm/y4bhh:mi:ss') a …

15 30 50 per page
1 2 3 next