All forum activity

#DateUserForumTypeThreadPost
5874426 Jul 2016 @ 09:48 PDTricejfxDatabaseTopicDifferent Column Orders for Stats Recommended by DIAGNOSTIC HELPSTATS? Hello, I am running into a spool space problem on tables that I just created, which had no statistics.  I employed the DIAGNOSTIC HELPSTATS ON FOR SESSION in order to get the recommended stat...
5874326 Jul 2016 @ 08:33 PDTfgrimmerTeradata StudioReplyTeradata Studio Express - OLD Versions@moncalieri, You can find the old versions of Studio Express on the Teradata Patch Server. 
5874226 Jul 2016 @ 08:03 PDTsachin.sebastianDatabaseReplyWhat is difference between Redistribution of rows and Duplication of small table in AMPsYes, that is correct at a high level. Redistribution will be based on hash code of the joining column(s)
5874126 Jul 2016 @ 05:04 PDTl3okConnectivityReplyConnectivity issueHi Have you managed to resolve your issue?
5874026 Jul 2016 @ 04:55 PDTabhishank18DatabaseReplyFastloadHey Khurram, I have got the answer for the question, after injecting an error in the record that record was discarded and loaded in the error table that could be accessed even after fastload comple...
5873926 Jul 2016 @ 03:18 PDTagarw491DatabaseReplyHelp in XML shreddingI am too facing the same error in function as shred gettables invalid annotated schema below are my xml and xsd <?xml version="1.0" encoding="UTF-8"?> <!--XML ...
5873826 Jul 2016 @ 02:53 PDTkamlesh114DatabaseTopicWhat is difference between Redistribution of rows and Duplication of small table in AMPsRelated to join strategy used by TD optimzer.   When we join table and see explain plain then  it show that rows are redistributed/duplicated on all AMPs based on join startegy use...
5873726 Jul 2016 @ 01:27 PDTvenkata_k01DatabaseTopicHow to get column data type and formatI am working on one automation process where data will be fetched from a table based on qualifying key passed as parameter. That qualifying key can be of type date/timestamp. I need to handle all f...
5873626 Jul 2016 @ 12:50 PDTaneelkumar04DatabaseReplyhow to handle Null values in FASTloadSorry for column7 also Nullif only.  
5873526 Jul 2016 @ 12:44 PDTaneelkumar04DatabaseTopichow to handle Null values in FASTload Define  colum (CHAR(19), nullif='                   '),  colum2 (CHAR(35), nullif=...
5873426 Jul 2016 @ 12:37 PDTaneelkumar04DatabaseReplyFastload Duplicate Records issuesI got the solution. Thanks for your valueble time.
5873326 Jul 2016 @ 12:27 PDTMONCALIERITeradata StudioTopicTeradata Studio Express - OLD VersionsHi all, Where I can find the Old version of TD Studio Express. I mean the version 15.00 or 15.10 , because I have problems with Data Lab view, so I need to try the old version. Anyone could help...
5873225 Jul 2016 @ 11:19 PDTagtsDatabaseReplyHelp needed for understanding of space default behavior and limitations or rulesThanks Khurram...
5873125 Jul 2016 @ 11:06 PDTfeinholzToolsReplyTPT 15.10 ODBC Operator : Bundled DataDirect Drivers !This is not true. We bundle both the 32-bit and 64-bit drivers with TPT. You do not have to purchase the license from DataDirect. However, you do need to obtain the license files from us.  
5873025 Jul 2016 @ 09:11 PDTmm185159ToolsReplyTPT 15.10 ODBC Operator : Bundled DataDirect Drivers !Yah, well, it sucks becasue you have to purchase a DataDirect license in order to use the 64-bit drivers.
5872925 Jul 2016 @ 08:31 PDTmc200018Teradata Database on VMWareReply"How to download TTU for fixing the bteq issue on mac"This problem can be happen when uncompatible TTU components co-exist on client laptop. Even if TeraGSS client package version 15.10.01 or higher is installed on a client, BTEQ version 15.10.00 ...
5872825 Jul 2016 @ 06:46 PDTzakywAnalyticsReplyQUERY IN ASTER Hi saeed  thanks for answer , before, what is the difference of create table by me with create table by you  ?  and do you have example query with the function LIKE in Aster saeed ...
5872725 Jul 2016 @ 05:46 PDTbranko.pAsterReplyAster database/schema/table space managementHi Saeed,  You mentioned it can be managed using options in AMC, where exactly in AMC do you do this as I've looked and cannot seem to find it. 
5872625 Jul 2016 @ 05:08 PDTMohanMuchivoluDatabaseTopicTPT Script Error While executingHi, I am getting below TPT error while reading from MQ  MQ_READER[1]: TPT19434 pmOpen failed. General failure (34): 'Teradata Websphere MQ AMOD/PIDMMain(!ERROR!).  --ERROR: Ignoring...
5872525 Jul 2016 @ 03:10 PDTtxrob74GeneralTopicHow to search multiple columns for specific textHello,  I have a table with multiple columns that display similar information and am trying to query multiple columns for a specific value.  for example the columns ID1, ID2 ID3 id1 ...
5872425 Jul 2016 @ 02:46 PDTrakaDatabaseTopicCASE statement vs UDFHi, I'm a java developer and new to TD and looking for some input/advice. We have a query where we are using "CASE". After rough profilling found this "CASE" part is takin...
5872325 Jul 2016 @ 02:16 PDTZackHoweDatabaseReplyUDF Default DatabaseI am looking for the exact same thing.  We have a library of functions that we want to be able to use without having to qualify them.  I was hoping there was a way to add my own database ...
5872225 Jul 2016 @ 02:13 PDTfeinholzToolsReplyCtrl-A delimiter with TPT Export.There is an attribute for the DataConnector operator (I think still undocumented) called TextDelimiterHex. Set that to '0A' and the DC operator should write out that character as the field...
5872125 Jul 2016 @ 12:32 PDTtranlmDatabaseTopicpartition by a superset of multiple columnsHi guys,   Hoping a knowledgeable pro can help me with a problem I'm stuck on. I have a table with multiple columns for different values, with an example given bel...
5872025 Jul 2016 @ 11:27 PDTsrivigneshknToolsTopicCtrl-A delimiter with TPT Export.Hi,  I want to use CTRL-A as delimiter for TPT exports, I would like to know how to specify this in the TPT script. Thanks & Regards, Srivignesh KN

Pages