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?