All forum activity

#DateUserForumTypeThreadPost
5854218 Jul 2016 @ 10:51 PDTawennyToolsReplyEncryted Password File for FastExportOn Unix systems, there are two different modes of storing passwords. One is with a passphrase, you have to unlock always manually after you restart the server. The other one is without the requir...
5854118 Jul 2016 @ 09:51 PDTAMIT@TDDatabaseTopicData DictionaryHello Guys i am new to td. i want to know about DD. Q1:- can we increase data Dictionary size ? Q2:- if we can not increase then what is a ratio of data Dictionary space to total terad...
5854018 Jul 2016 @ 09:19 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPTGetting the below error when ExportSelectStmt variable is used in the job variable file. Teradata Load Utility Version 15.10.00.03 64-Bit TDLOAD: TPT05528: Error: No data source is not specified...
5853918 Jul 2016 @ 04:03 PDTFredToolsReplyZero records are fetching when using where statement in TPTIf you are using the $EXPORT template and providing the SELECT at the job level, use the ExportSelectStmt variable.
5853818 Jul 2016 @ 03:27 PDTFredDatabaseReplyConvert the data in the Table into XML formatDon't use a quoted identifier for the XML Element Name.
5853718 Jul 2016 @ 03:20 PDTFredDatabaseReplyFunction quantile throws a numeric overflow error in a large tableQUANTILE is deprecated; Teradata recommends you use  standard SQL instead: (RANK() OVER (ORDER BY ACCT_ID) -1)*10/COUNT(*) OVER() as decile But that doesn't solve your issue. Like QUANTI...
5853618 Jul 2016 @ 01:36 PDTJustinSToolsTopicIn List Blues - How to make large In List Queries More Efficient I work for a bit company with a lot of Business Objects users. One of our most popular universes points to a Teradata environment. This universe is by far our best BI resource. It has a ton of data...
5853518 Jul 2016 @ 01:10 PDTPrateeDatabaseReplyDifference between event code and crash codeThanks...
5853418 Jul 2016 @ 01:04 PDTM.Saeed KhurramToolsReplyEncryted Password File for FastExportHave you made any update to AIX ?
5853318 Jul 2016 @ 01:03 PDTmhusseyAsterTopicSort Sankey Diagram order-Hey everyone, I've created some Sankey Diagrams in Aster, and I am trying to find out if there is any way to sort the order of the boxes on each side. Currently, they show up according to alph...
5853218 Jul 2016 @ 12:33 PDTzhenwuyangDatabaseTopicFunction quantile throws a numeric overflow error in a large tableI have a large table and it holds about 33 billion records. I need to run simple quantile function but it failed with a numeric overflow error. SELECT acct_id, QUANTILE (10, ACCT_ID) AS decile &nb...
5853118 Jul 2016 @ 12:25 PDTGlassGeneralReplyUse of TABLE Keyword select statement Check out manual  on SQL functions. This is syntax for using Table UDF.   Rglass
5853018 Jul 2016 @ 10:35 PDTrandy.dycus2ToolsReplyEncryted Password File for FastExportI mean that after a reboot of the AIX server, calls to the Wallet that worked before are no longer working.    *** CLI error: CLI2: TDWALLETERROR(543): Teradata Wallet error. The wallet...
5852918 Jul 2016 @ 09:58 PDTM.Saeed KhurramToolsReplyEncryted Password File for FastExportWhat do you mean by reenter?  If you have tdwallet installed, simply run the tdwallet, add entries and use them in script as given in the example.  
5852818 Jul 2016 @ 08:01 PDTrou_oliToolsReplyTPT read fixed file and convert space to null valuethanks Carlos
5852718 Jul 2016 @ 07:47 PDTrandy.dycus2ToolsReplyEncryted Password File for FastExportWe have found that we have to reenter Wallet entries after a reboot (AIX environment).  Is this normal?   Thanks in advance, Randy
5852618 Jul 2016 @ 07:35 PDTskneeliAsterReplyRunning AnyDatabase2Aster function error: java.lang.Null.ExceptionDid you find any solution for this issue.
5852518 Jul 2016 @ 07:20 PDTMadhumGeneralReplyinterview helpHi..please share to latha624@gmail.com Thanks in Advance.
5852418 Jul 2016 @ 07:18 PDTMadhumGeneralTopicFree text columns adding in the table   Hi All,   We are getting requirements to add a list of free text (clob) columns from ODS to a table. Potentially that will result in 5-6 columns of type varhcar(2000) or varchar(400...
5852318 Jul 2016 @ 07:07 PDTkathir_chaserDatabaseTopicConvert the data in the Table into XML formatHI All, I'm trying to convert the data in a table to XML format for an application. And the output I get is <Error>. Also , when i try to run the below statement i am gettting the same:...
5852218 Jul 2016 @ 06:13 PDTCarlosALToolsReplyTPT read fixed file and convert space to null valueHi. If file is TEXT the SCHEMA fields should be CHAR. You must use CASE WHEN in the SELECT ... FROM OPERATOR  FILE_xxx_READER. HTH. Cheers. Carlos.
5852118 Jul 2016 @ 05:10 PDTWAQDatabaseReplyCalculate column value based on previous computed valueThanks a lot, this is what I was looking for.
5852018 Jul 2016 @ 03:00 PDTkudentovDatabaseReplyAssigning a value of 1 only to the lowest value for an address type for each customerID in a tableThanks for the reply, Dieter!
5851918 Jul 2016 @ 02:39 PDTNewbieTDGeneralTopicUse of TABLE Keyword select statement select subq.sub_col1,subq.sub_col2,c.c2,c.c3.c.c4 select a.col1 sub_col1,b.col2 sub_col2,b.col3 sub_col3 Schemaname.Tab1 a, (select col1,col2 col3 from Schemaname.Tab2) b on a.col1=b.col1) as ...
5851818 Jul 2016 @ 02:28 PDTindra91ToolsTopicTDCH-TPT Interface--For loading into HadoopI need to ingest volume of data from Teradata to Hadoop using TPT.I saw in the TPT documentation that we can achieve this using TDCH-TPT interface.I would like to know the following about the proce...

Pages