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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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;

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 …

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", …

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 …