Unanswered Questions

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
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
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
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
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
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
0answers
14 views

Need answers to the anomaly in calculating the timestamp difference

I have a query which calculates the timestamp difference as Duration in hours & minutes and Then Rounds it to the closest hour based on the rule: For ex: If minutes > 29, then …
0
votes
0answers
42 views

decimal format with comma

Need help in converting this $875575.00 to $875,575.00 another example: $95890.00 to $95,890.00 Thanks in Advance. Regards, TDHelp
0
votes
0answers
37 views

Is it true that PSF’s Priority Scheduler Administrator (PSA) is not active on a new Teradata install?

Until we haven't run the DBCManager setup on a fresh Teradata install, there are no PSA configuration tables. And also none of TDWM tables. So by default which Priority Scheduler …
0
votes
0answers
32 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 …
-1
votes
1answer
4 views

Deposit casino bonuses

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

What are trips in poker?

Soi Nguyen, Nguyen Soi
-1
votes
1answer
3 views

WSOP Game Final

When will be held the final of WSOP?
-1
votes
1answer
4 views

Register a .com for free!

Can I register a .com domain name for free?