Tagged Questions

0
votes
1answer
22 views

Channel Node in Teradata

Can someone tell me about channel nodes in teradata and what exactly it does. I know that channel nodes are used managing connectivity between channel attached client machine and T …
0
votes
1answer
53 views

Teradata sql assistant compatability with DB2 for LUW V9.7

I'd like to know where I can find any documentation about Teradata SQL Assistant 06.02.00 and it's compatability with DB2 for LUW V9.7.
0
votes
2answers
151 views

3848: The ORDER BY clause must contain only integer constants

Hi , in the order by clause if I give column name , I get error . can anybody help pls .
0
votes
1answer
189 views

Difference between ‘Delete’ and ‘Delete All’

hi all is there a difference between 'delete' and 'delete all' in teradata(as in indexes being dropped, transient journal, statistics, explain plan etc)? Does it change with versi …
0
votes
1answer
92 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 …
1
vote
2answers
102 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 …
1
vote
2answers
429 views

Oracle update to teradata update with select subquery

Here is the oracle query .Can anybody give me teradata query . update table_a A set display_format = nvl((select prop.propvalue from table_a B, table_c C …
0
votes
1answer
217 views

Teradata Database Setup errors out for some queries

I have posted the same issue on: http://developer.teradata.com/forum/tools/teradata-database-setup-errors-out-for-some-queries We have installed Teradata on Windows machine. Now o …