All forum activity

#DateUserForumTypeThreadPost
5731124 May 2016 @ 01:11 PDTtotalzoomGeneralReplytable needs changeroll     auto    sm   med     large    exec 121     1         0     0          0  ...
5731024 May 2016 @ 01:09 PDTtotalzoomGeneralReplytable needs change roll# auto small med large exec 121 1 0 0 0 0 ...
5730924 May 2016 @ 01:01 PDTtotalzoomGeneralTopictable needs changeHi, 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  for eg:   125 has fl...
5730824 May 2016 @ 12:21 PDTDiEgoRDatabaseReplyTeradata Error: [3704] '' ('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...
5730724 May 2016 @ 10:01 PDTmandalapusriConnectivityTopichive server2 connection through Teradata Studio not workingWhat could be the reason for the below error. Error Could not connect to New Hadoop Hortonworks. Error creating SQL Model Connection connection to New Hadoop Hortonworks. (Error: Error while proc...
5730624 May 2016 @ 08:45 PDTASCHARANDatabaseReplyWith recursive in a SelectThe 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); INS...
5730524 May 2016 @ 08:39 PDTASCHARANDatabaseReplyWith recursive in a SelectHi 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    ...
5730424 May 2016 @ 06:32 PDTArpan.RoyToolsReplyNeed Help regarding TPT ODBC OperatorHi 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...
5730324 May 2016 @ 05:35 PDTDiEgoRTeradata ApplicationsReplyExport multiple SQL's results into single excel sheet by sheetTeradata 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...
5730224 May 2016 @ 04:38 PDTdnoethDatabaseReplyPrimary key and Primary index on a same columnThis 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 (...
5730124 May 2016 @ 04:12 PDTAtardecerR0j0GeneralReplytranspose in teradata(columns to rows viseversa)When you get the last answerset you should resubmit that answerset as a query
5730024 May 2016 @ 04:11 PDTAtardecerR0j0GeneralReplytranspose in teradata(columns to rows viseversa) --Replace YourDB drop table YourDB.MySource; create multiset table YourDB.MySource( myMode char(5), week1 smallint, week2 smallint, week3 smallint, week4 smallint, week5 smallint, week6 ...
5729924 May 2016 @ 03:19 PDTProgMartin95DatabaseReplyPrimary key and Primary index on a same columnHi i'm following this post, could someone give an answer to barani_sachin last comment?  
5729824 May 2016 @ 12:54 PDTrubenjdcDatabaseReplyTIPS TO CONVERT DECIMAL TO VARCHARGood 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!!
5729723 May 2016 @ 05:14 PDTjessielinTeradata StudioReplyUsing SQL History tab slows Studio to a crawlI 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...
5729623 May 2016 @ 04:28 PDTwrightjbDatabaseReplyWhen 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!
5729523 May 2016 @ 02:18 PDTac110057Teradata Database on AWSReplyHow 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...
5729423 May 2016 @ 02:00 PDTac110057Teradata Database on AWSTopicHow do I setup Server Management (CMIC) on AWS (Amazon Web Services)?
5729323 May 2016 @ 12:36 PDTielbertAsterReplyREGEXP_SUBSTR Function in AsterHow about this: SELECT SUBSTRING('This is sample text day_of_month is 17--this value should be returned' FROM 'day_of_month is ([[:digit:]]+)' ) Result: 17 Igor
5729223 May 2016 @ 11:59 PDTCarlosALDatabaseReplyDET DEFINE OFF in SQL DeveloperHi. 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...
5729123 May 2016 @ 11:12 PDTabhishek.jadhavDatabaseReplyAutomating release lock after database copy failureYou 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 ...
5729023 May 2016 @ 10:59 PDTGlassGeneralReplyHow to run BTEQ in Windows machinYou can type Bteq at the command prompt after you have installed the software or start from a batch file     Rglass
5728923 May 2016 @ 10:44 PDTabhishek.jadhavDatabaseReplyWho 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 “...
5728823 May 2016 @ 10:06 PDTamirkDatabaseReplyDET DEFINE OFF in SQL DeveloperThanks 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...
5728723 May 2016 @ 09:37 PDTtomnolanDatabaseReplyMacro vs Procedure - SQL SECURITYTeradata Database Reference / SQL Data Control Language / Chapter 2 "Statement Syntax / section "Grant (SQL Form) / subsection "Security Considerations With the CREATE MACRO Privileg...

Pages