All Questions

-1
votes
1answer
4 views

Deposit casino bonuses

What are the Advantage for the Casino player ?
-1
votes
1answer
4 views

Register a .com for free!

Can I register a .com domain name for free?
0
votes
1answer
19 views

variable interval size

I need a query and DML that gets all the rows created in the last N days. It will run in a stored procedure. So I tried this: insert into T2 (...) select whatever from T …
0
votes
1answer
20 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
372 views

Add months teradata

Hi, I am facing some challenges with Add months function in TD, in Oracle the date range conditions are derived based on date value calculating the end of the month and then addin …
0
votes
2answers
146 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
52 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
1answer
259 views

Teradata metadata help

Hello, I have a very difficult question to ask you. I have loads of queries for different reports and applications and I wanted to separate out columns and associated tables from …
0
votes
2answers
201 views

Recursive Order by

Hi, I need help in With Recursive query order by, In Oracle, the query has rownum in the select list for connect by start with hierarchical view and was ordered by with rownum. S …
0
votes
1answer
25 views

Does the column AwtInUseMax from ResUsageSpma provide aggregated value for all the AMPs in the Node?

In ResUsageSpma data is reported per node. The definition of column AwtInUseMax is given as: Peak number of AWTs (Max) on this node. This is not the Peak or the Max value stored i …
1
vote
2answers
178 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 …
0
votes
3answers
1k 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
2answers
345 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 …
0
votes
1answer
120 views

Speeding up SELECT MAX(timestamp_column) FROM T, when T is loaded via continuous TPump

How can I speed up a query that's currently doing a full table scan to get the maximum value of a timestamp column? I have a large table with a timestamp column. There is a TPump …
0
votes
1answer
101 views

Can multiple account ids (mapping to multiple Performance Groups) be supplied for a Teradata connection?

When connecting to Teradata via JDBC, we can supply any of the account ids available for the user we are connecting with. e.g. if my user has Account=$SINCITY$,$H,$Mon&H$ Then …

15 30 50 per page
1 2 3 4 next