All forum activity

#DateUserForumTypeThreadPost
5806728 Jun 2016 @ 12:18 PDTrahul1987DatabaseReplyHow to Write the correct syntax for JoinHi Dieter, Thanks for the reply but i have the condition by AND statement. I modified the query:- SELECT COUNT(DISTINCT a.sku),COUNT(DISTINCT b.sku),COUNT(DISTINCT c.sku) FROM skuinfo a I...
5806627 Jun 2016 @ 11:39 PDTdnoethDatabaseReplyHow to Write the correct syntax for JoinNobody will tell that this query is right (otherwise they don't know about SQL). You join three tables but the second ON is missing. And when you explicit join syntax the ON is mandatory, so ...
5806527 Jun 2016 @ 11:35 PDTdnoethAnalyticsReplyHelp extracting select time period records ( rank / any other way)Ops, the ROWS part was missing:  select COLA, COLB, COLC, min(COLB) over (partition by COLA order by COLC rows between 1 following and 1 following) as nextCOLB...
5806427 Jun 2016 @ 08:54 PDTaasim.nazar@gmail.comToolsTopicTPT Failure: TPT Data connector Error "TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 4." for FastLoad JobDear Feinholz and All,                                I have been loading data from Text file Delimited using &...
5806327 Jun 2016 @ 07:07 PDTtomnolanDatabaseReplyDatabase per object type -- Best practice or over engineered?>>> Is there a way to create a generically named link or alias to a database?   No, the Teradata Database does not offer that feature.   >>> I see "DB Link"...
5806227 Jun 2016 @ 05:59 PDTsri67AnalyticsReplyHelp extracting select time period records ( rank / any other way)Thanks Dieter for the help and sorry to have responded back too late. I think the requirement specified by me was not clear and the solution specified do not return any rows. The nextColb has alwa...
5806127 Jun 2016 @ 05:27 PDTfgrimmerTeradata StudioReplyTeradata studio installation is failing...Michael, Not sure what you are asking? Teradata Studio Express is a client application that connects to your Teradata server. Do you have a Teradata server that you can connect to?
5806027 Jun 2016 @ 05:09 PDTemchisholmTeradata StudioReplyIssue Downloading Studio even After Java installedSeems this is a common issue for everyone. :)   Windows 10 (64 bit)   Trying to install Teradata Studio Express nt-x8664 (64 bit)   Java is 64 Bit ... java -version j...
5805927 Jun 2016 @ 04:37 PDThvganipineniDatabaseReplyTransaction QUERY_BAND not workingYou can use a simple  BEGIN CODE; --Set Query Band Multiple statements. END CODE;   Let me know if it doesnt work. 
5805827 Jun 2016 @ 04:34 PDTAVOTViewpointReplyData Labs Upgrade QuestionThanks Gary for the response. Appreciate your help. 
5805727 Jun 2016 @ 04:31 PDThvganipineniTrainingReplyTE0-142 Study HelpDid you try Teradata Certification Books? Also, the comprehensive documentaion is also a good idea.
5805627 Jun 2016 @ 04:08 PDTmm185159DatabaseReplyTransaction QUERY_BAND not workingSo, your right, it is more like BTEQ. So far, the only way I can get it work is to use BT/ET and set the transaction qb as the first statement after the BT; statement. Seems to be cumbersome, espe...
5805527 Jun 2016 @ 04:01 PDTmm185159AsterTopicusing Teradata Stored Procedures to pull data into AsterI am unable to get a stored procedure call that returns a dynamic data set to execute from Aster via the TDConnector. Is this becasue the QueryGrid function load_from_teradata only supposts a SQL S...
5805427 Jun 2016 @ 03:38 PDTtimlisa20ConnectivityTopicODBC error (64bit)Hoping someone can help with this issue as I have spent way too long trying to troubleshoot on my own. I have the latest version of Teradata Studio(15.11) and I am running Windows7(64bit). When I...
5805327 Jun 2016 @ 01:59 PDThagrdanDatabaseReplyDatabase per object type -- Best practice or over engineered?Thank you; I completely agree that your solution is ideal.  :-) Is there a way to create a generically named link or alias to a database?  I see "DB Link" being talked about bu...
5805227 Jun 2016 @ 01:47 PDTBTEQDEVTEAMToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?And actually for 15.10.01 there is now a more recent .03 efix but it is .02 that you minimally need.  
5805127 Jun 2016 @ 01:45 PDTtomnolanDatabaseReplyspecial char 0xFF convert to 0X1A with character set LATIN1_0A Are you trying to use the Euro sign? That won't work with session character set LATIN1_0A.   According to the Teradata Database Reference / International Character Set Support / Chapter ...
5805027 Jun 2016 @ 01:43 PDTBTEQDEVTEAMToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?Efix versions equal to or higher than what I listed will have it. So to get it now, you will need to pick up the latest efix version for 15.10.01 which is... 15.10.01.02 It will also be in the bas...
5804927 Jun 2016 @ 01:37 PDTTDDeveloperToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?Hooray! Thanks for the enhancement! Thank you! Thank you! So I suppose any minor version equal to or higher than the ones listed here in each of the major versions will have this enhancement ...
5804827 Jun 2016 @ 12:54 PDTBTEQDEVTEAMToolsReplyHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?Very recently, by way of BTEQ efixes, we've added support for using a new SYSTEMRETURNCODE keyword as part of an .IF command condition to enable the return code value resulting from using a .OS...
5804727 Jun 2016 @ 12:38 PDTrahul1987DatabaseTopicHow to Write the correct syntax for Joinq) Use COUNT and DISTINCT to determine how many distinct skus there are in the skuinfo, skstinfo, and trnsact tables. Which skus are common to all tables, or unique to specific tables? A) I was tr...
5804627 Jun 2016 @ 11:43 PDTsvdataDatabaseTopicMaximum row length exceeded in recursive query      INS INTO Definitions (ID,SID, Query_txt) WITH RECURSIVE SimpleDef_Concat (ID,SID, Query_txt,LVL) AS ( SELECT ID,SID,Query_txt (VARCHAR(62000)), 1 FRO...
5804527 Jun 2016 @ 11:35 PDTgrybackViewpointReplyData Labs Upgrade QuestionAt a high level, Data Lab has two parts to the infrastructure, the first being the Teradata DB objects and secondly the Data Lab infrastructure related to the Data Lab Viewpoint portlet. When upgra...
5804427 Jun 2016 @ 11:13 PDTMichael.musicGeneralReplysteps to install td-ttu-15.10.05_for_Windows Hey mu CPU does not support VT-x i have checked in the BIOS and not able to use VM Ware so i use teradatafor the same.pls lket me know. and HOW pls it is veryurgent i have to worked on ...
5804327 Jun 2016 @ 11:10 PDTMichael.musicTeradata StudioReplyTeradata studio installation is failing... Hey mu CPU does not support VT-x i have checked in the BIOS and not able to use VM Ware so i use teradatafor the same.pls lket me know. and HOW pls it is veryurgent i have to worked on ...

Pages