All forum activity

#DateUserForumTypeThreadPost
5856719 Jul 2016 @ 09:58 PDTdnoethToolsReplyIn List Blues - How to make large In List Queries More Efficient Yep, this doesn't need to be a Stored Procedure, a Teradata Macro will also work.   But literal strings are limited to 31000 characters in Teradata, you will hit this limit. You might p...
5856619 Jul 2016 @ 09:45 PDTfeinholzToolsReplyTDCH-TPT Interface--For loading into HadoopThe use of TDCH by TPT is basically performed by TPT sending a command to the name node of the Hadoop cluster to execute the TDCH command, passing the needed information as command line options to ...
5856519 Jul 2016 @ 09:32 PDTindra91ToolsTopicFloat data type export using Fast ExportHello everyone,   I am trying to export a table with float data type using FastExport utility.As we know Teradata rounds-off any float values where number of digit is greater than 15. For in...
5856419 Jul 2016 @ 09:21 PDTfeinholzToolsReplyTPT - ScriptingWhat version of TPT are you using? That would dictate what type of "template" and "generated schema" features you can use. It would also dictate whether you can use Easy Loade...
5856319 Jul 2016 @ 09:11 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTFor your versiobn of TPT, continue to use SelectStmt. We are "fixing" TPT to also accept ExportSelectStmt, but that is not completed yet. I will need to see a complete log (the .out fil...
5856219 Jul 2016 @ 09:10 PDTToddAWalterToolsReplyDetermine #sessions to set for load / exp jobsBetter yet, let WLM manage the number of sessions and only change the ones that really need exceptions via WLM rules. 
5856119 Jul 2016 @ 09:07 PDTToddAWalterToolsReplyIn List Blues - How to make large In List Queries More Efficient What Teradata release is being used?   What does the explain plan look like for the 4500 class case?   On current releases, the Teradata optimizer should be doing this automatically. ...
5856019 Jul 2016 @ 09:07 PDTfeinholzToolsReplyDetermine #sessions to set for load / exp jobsThe calculation that is often used in TASM (TDWM, workload management) is:   If number of AMPs <= 20, then use 1 per AMP. If number of AMP > 20, then use 20 + (#AMPS/20)   But ...
5855919 Jul 2016 @ 07:42 PDTJustinSToolsReplyIn List Blues - How to make large In List Queries More Efficient What's a "tremendous amount" The big queries will be 5000- 10,000. Sometimes they will just run them about 4,500 at a time, over and over again. So if I am getting the gist of your ...
5855819 Jul 2016 @ 07:28 PDTawennyToolsReplyTPT - ScriptingYou can use this perl program: https://github.com/tdawen/td_devel/blob/master/teradata/cptab.pl But I haven't used it for a long time. Maybe it requires some tweaks. You can also remove...
5855719 Jul 2016 @ 07:06 PDTM.Saeed KhurramToolsReplyTPT - ScriptingYou can use template and wrtie a macro or SP to take input the table name or loop through list of tables and generate TPT script against each table.
5855619 Jul 2016 @ 06:36 PDTCarlosALToolsReplyTPT - ScriptingHi.heers. You can use Templates and Generated Schemas. Cheers. Carlos.
5855519 Jul 2016 @ 06:19 PDTrandy.dycus2ToolsReplyEncryted Password File for FastExportAndreas, Thank you very much.  I have not had a chance to test yet (reboot the server), but I fully expect this to be the answer I was looking for.   Thanks again for taking to time to ...
5855419 Jul 2016 @ 06:09 PDTkathir_chaserDatabaseReplyConvert the data in the Table into XML formatTried that as well. But doesn't help...
5855319 Jul 2016 @ 06:07 PDTKNToolsTopicTPT - ScriptingHello Folks I have a requirement to move 90 tables totalling up to 200 GB from one Teradata system to an another Teradata system.. While i know there are different options i plan to use TPT t...
5855219 Jul 2016 @ 05:45 PDTdnoethDatabaseReplyFunction quantile throws a numeric overflow error in a large tableCheck if you can avoid two OLAP-steps, SUM(CAST(1 AS BIGINT)) OVER (...) might be ok (if the data is not unique rows with the same value might be assigned to two quantiles)   Btw, TD15.10 fi...
5855119 Jul 2016 @ 04:43 PDTCarlosALDatabaseReplyUsing Volatile table in stored procedureHi. If you use a cursor as a resulset for returning rows to a user and this cursor selects rows from a volatile table, then you must declare it as a dynamic cursor, because the volatile table does...
5855019 Jul 2016 @ 04:13 PDTnimish_123DatabaseTopicSQL Performance issueHi All, I need your input for performance improvement of below SQL (with EXPLAIN PLAN). This SQL was running fine previously but suddenly having performance issue. We have refreshed the STATS but...
5854919 Jul 2016 @ 03:58 PDTdnoethDatabaseReplyData DictionaryThere's no need to increase the Data Dictionary size. Teradata's DD are the tables located in dbc and there's usually a large perm space assigned to it (it also includes the Transient ...
5854819 Jul 2016 @ 03:51 PDTdnoethToolsReplyIn List Blues - How to make large In List Queries More Efficient What's a "tremendous amount", 100s, 1000s or 10000s of values? You might investigate usage of STRTOK_SPLIT_TO_TABLE, either as part of the Select or as Insert/Select in a Macro (hope...
5854719 Jul 2016 @ 03:50 PDTAtardecerR0j0DatabaseReplyUsing Volatile table in stored procedureThere is no problem using volatile tables in a store procedure  I used on a SP where after executing the SP i should review a volatile table, this table sometimes existed previous to the exec...
5854619 Jul 2016 @ 03:02 PDTmcfabreroDatabaseTopicCHARACTER SET LATIN versus CHARACTER SET UNICODEHi All, I would like to ask for your help on explaining and elaborating the difference between columns having data types set to LATIN and those set to UNICODE. Currently encountering a spool spac...
5854519 Jul 2016 @ 02:44 PDTMeenakshiMDatabaseReplyUsing Volatile table in stored procedureHi, Even I need help on this topic. I have to create multiple volatile tables inside a stored procedure and use them for returing output to user in the form of cursor. But I am unable to compile t...
5854418 Jul 2016 @ 11:51 PDTKNToolsTopicDetermine #sessions to set for load / exp jobsHello Gurus Is there a rule of thumb that one should follow for determining the number sessions that should be set for a load or fexp jobs? Suppose if my system is a 4 node system with 40amps/nod...
5854318 Jul 2016 @ 11:37 PDTawennyToolsReplyEncryted Password File for FastExportAfter running a test, the error message shown with items added via "add" after a reboot is: *** CLI error: CLI2: TDWALLETERROR(543): Teradata Wallet error. The wallet password has not...

Pages