|57311||24 May 2016 @ 01:11 PDT||totalzoom||General||Reply||table needs change||roll auto sm med large exec
121 1 0 0 0  ... |
|57310||24 May 2016 @ 01:09 PDT||totalzoom||General||Reply||table needs change||
|57309||24 May 2016 @ 01:01 PDT||totalzoom||General||Topic||table needs change||Hi, I have table like below: All i need is if roll# has flag in mutiple columns highest heirarcy column should show the flag and rest columns should be null
125 has fl... |
|57308||24 May 2016 @ 12:21 PDT||DiEgoR||Database||Reply||Teradata Error:  '' ('0A'X) is not a valid Teradata SQL token.||The solution I found is to remove all new lines \n from the SelectStmt. This is very annoying.
Personally I think that this is a scandal for Teradata to have such bugs in their code for such a lo... |
|57307||24 May 2016 @ 10:01 PDT||mandalapusri||Connectivity||Topic||hive server2 connection through Teradata Studio not working||What could be the reason for the below error.
Could not connect to New Hadoop Hortonworks. Error creating SQL Model Connection connection to New Hadoop Hortonworks. (Error: Error while proc... |
|57306||24 May 2016 @ 08:45 PDT||ASCHARAN||Database||Reply||With recursive in a Select||The VT table in above example is below.
CREATE VOLATILE TABLE VT (question_id INTEGER, element_id INTEGER
)ON COMMIT PRESERVE ROWS;
INSERT INTO VT VALUES (1,7);
|57305||24 May 2016 @ 08:39 PDT||ASCHARAN||Database||Reply||With recursive in a Select||Hi Guys,
I want to know if there is anyway i can use WITH and WITH RECURSIVE in a single sql. I have a requirement for something like
-- To convert the below result
|57304||24 May 2016 @ 06:32 PDT||Arpan.Roy||Tools||Reply||Need Help regarding TPT ODBC Operator||Hi Steve,
With -h as 100 M, I'm able to write the data into a flat file. But, when we are using Informatica we are getting throughput around 3000, but when I'm using TPT (ODBC Operator wit... |
|57303||24 May 2016 @ 05:35 PDT||DiEgoR||Teradata Applications||Reply||Export multiple SQL's results into single excel sheet by sheet||Teradata basic utilites are pretty lame regarding basic MS office related stuff. I understand, they were developed before MS was even a company. But it makes the life of an analyst rather frustrati... |
|57302||24 May 2016 @ 04:38 PDT||dnoeth||Database||Reply||Primary key and Primary index on a same column||This seems to be a bug, a USI on top of a NUPI in this case is totally stupid.
The only case where this might be useful is a partitioned table where the partitioning column is not part of the PI (... |
|57301||24 May 2016 @ 04:12 PDT||AtardecerR0j0||General||Reply||transpose in teradata(columns to rows viseversa)||When you get the last answerset you should resubmit that answerset as a query
|57300||24 May 2016 @ 04:11 PDT||AtardecerR0j0||General||Reply||transpose in teradata(columns to rows viseversa)||
drop table YourDB.MySource;
create multiset table YourDB.MySource(
week6 ... |
|57299||24 May 2016 @ 03:19 PDT||ProgMartin95||Database||Reply||Primary key and Primary index on a same column||Hi i'm following this post, could someone give an answer to barani_sachin last comment?
|57298||24 May 2016 @ 12:54 PDT||rubenjdc||Database||Reply||TIPS TO CONVERT DECIMAL TO VARCHAR||Good morning!
I did the last try today with your answer and it works!!!
I used the another cast option and tpt export
Thanks so much for your help Dieter!!
|57297||23 May 2016 @ 05:14 PDT||jessielin||Teradata Studio||Reply||Using SQL History tab slows Studio to a crawl||I notice a similar issue on Windows. After the sql history has accumated after a certain threadhold, the sql editor becomes very slow.
I found that if I check "Automaticaly clean up result hi... |
|57296||23 May 2016 @ 04:28 PDT||wrightjb||Database||Reply||When you give a calculated column the same alias as an existing column, how do you refer to the new value?||Ah, I guess I forgot that union doesn't rely on the column aliases. Thanks Dieter, that solution works for me!
|57295||23 May 2016 @ 02:18 PDT||ac110057||Teradata Database on AWS||Reply||How do I setup Server Management (CMIC) on AWS (Amazon Web Services)?||1) On your Teradata Database image and on your viewpoint image in addition to the default ports that are opened make sure you open ports 5180, 5190, 22, and 1025 in your security group t... |
|57294||23 May 2016 @ 02:00 PDT||ac110057||Teradata Database on AWS||Topic||How do I setup Server Management (CMIC) on AWS (Amazon Web Services)?|| |
|57293||23 May 2016 @ 12:36 PDT||ielbert||Aster||Reply||REGEXP_SUBSTR Function in Aster||How about this: SELECT SUBSTRING('This is sample text day_of_month is 17--this value should be returned' FROM 'day_of_month is ([[:digit:]]+)' )
|57292||23 May 2016 @ 11:59 PDT||CarlosAL||Database||Reply||DET DEFINE OFF in SQL Developer||Hi.
You must execute the script with an '@' preceding the .sql file or by using F5 (run script) if you are executing the commands in a SQL worksheet.
SET DEFINE OFF works for me e... |
|57291||23 May 2016 @ 11:12 PDT||abhishek.jadhav||Database||Reply||Automating release lock after database copy failure||You can test the "Forced" option for Release Lock and see it works for you.
Forced = Instructs Teradata ARC to try and release any placed locks if the archive fails. However there ... |
|57290||23 May 2016 @ 10:59 PDT||Glass||General||Reply||How to run BTEQ in Windows machin||You can type Bteq at the command prompt after you have installed the software or start from a batch file
|57289||23 May 2016 @ 10:44 PDT||abhishek.jadhav||Database||Reply||Who dropped the table in teradata?||
If the table has “online logging” enabled, we need to disable online logging when table is dropped.
But currently for most of the drop table statements Teradata submits a “... |
|57288||23 May 2016 @ 10:06 PDT||amirk||Database||Reply||DET DEFINE OFF in SQL Developer||Thanks for your response, Carlos.
My original query looks like this:
SELECT a,b,c, FROM table_a
WHERE a = 'Abercombie & Fitch';
When I run the query, I get a dialog box asking for t... |
|57287||23 May 2016 @ 09:37 PDT||tomnolan||Database||Reply||Macro vs Procedure - SQL SECURITY||Teradata Database Reference / SQL Data Control Language / Chapter 2 "Statement Syntax / section "Grant (SQL Form) / subsection "Security Considerations With the CREATE MACRO Privileg... |