#DateForumTypeThreadPost
14107 Nov 2014 @ 01:29 PSTDatabaseReplyEncryption in the indexYes it can. But then use of the index will only be made if you write the query to provide the encrypted value for comparison rather than the clear value.   WHERE index_field=ENCRYPT_Funct(&l...
14006 Nov 2014 @ 06:06 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)You would not have to Union if the avg was always within the year and not overlapping. Since the unbounded preceding will go to the beginning of the partition, you could partition by the year and i...
13906 Nov 2014 @ 01:30 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)preceeding and following may only specify positive integers, expressions are not allowed. If you just say ROWS UNBOUNDED PRECEDING it will go from the beginning of the set to and including the cur...
13806 Nov 2014 @ 10:39 PSTDatabaseReplyDisadvantages of CompressionnDepends on which compression you are asking about... All compression forms on Teradata have no impact on users and creates no limitations on joining, comparing, accessing, returning or any ot...
13705 Nov 2014 @ 01:34 PSTDatabaseReplyhow to run multiple stored procedures in parallel ?If you wish to have two or more SPs run concurrently, they must be run on separate sessions. We do not have enough information about what is going to happen inside the procedure to be able to run t...
13631 Oct 2014 @ 06:27 PDTDatabaseReplyInvalid TimeTM is your column name. You have to insert into DU, your table name. 
13510 Oct 2014 @ 04:44 PDTDatabaseReplyPartitioning by a character columnThere is not a table or log that captures which partitions are used.   Also, be cautious when looking at the SQL for specific date qualifications because in many cases the partition inclusio...
13430 Sep 2014 @ 07:38 PDTDatabaseReplyData redistributionIt appears that after the optimizer planned the qualify over the tran_Id it forgot that the spool was still on the amps of the hash of tran_id. It knew that for the rank/partition/qualify because i...
13326 Sep 2014 @ 01:12 PDTDatabaseReplyTuning LIKE OperatorFor any LIKE match that is not a left substring match (eg LIKE 'test%') the optimizer has no way to match the requested value against any statistics. Therefore regardless of any indexes tha...
13211 Sep 2014 @ 01:24 PDTExtensibilityReplyReturn a Concatenated string from User defined Funtion through CursorThere are a number of threads on this forum which talk about using recursive query to implement a pivot or list_agg operation which appears to be what is desired here.
13108 Sep 2014 @ 06:19 PDTDatabaseReplyDatabase backup failing due to untranslatable characters in a table The backup utility does not look at the contents of the record and would not notice untranslatable characters. When it says internal error it means that there is an issue with the software and y...
13003 Sep 2014 @ 06:53 PDTGeneralReplyWithout using Join keyword how can we retrive matching rows from both the tablesIf the question is just the join keyword then just use the traditional join syntax: SELECT * FROM A, B WHERE A.C1=B.C1;
12902 Sep 2014 @ 02:57 PDTDatabaseReplyNew in Release 13 ? Alter table not possible on columns with statisticsNot clear what you mean by a production crash. If you had a failure of the Teradata database then it should be reported to the Teradata Global Support Center so that it can be found and repaired. ...
12802 Sep 2014 @ 08:42 PDTDatabaseReplyTemporals and Outer JoinsIf you are getting 3610, that is a SW fault and should be reported to the Teradata Global Support center. Please write an incident.
12720 Aug 2014 @ 08:03 PDTDatabaseReplyGetting AMP step failure errorUnfortunately you have encountered a software bug. Please have your Teradata DBA/admin folks raise an incident to Teradata to investigate and repair it.
12619 Aug 2014 @ 02:34 PDTDatabaseReplyPartition effectiveness- If the optimizer chooses to use partitions as in your initial example, it will be less costly than a full file scan. There is no separate overhead for scanning individual partitions, think of it ...
12506 Aug 2014 @ 08:46 PDTDatabaseReplyBTEQ Import going to DELAYED stateThis is expected behaviour for a TASM throttle rule if there is a rule in place that applies to you or your work and there is a lof of other work going on. BTEQ IMPORT is not a utility, it is simpl...
12430 Jul 2014 @ 03:00 PDTAnalyticsReplyGenerate a automated Nested CASE STATEMENT using entries from a tablePerhaps a different way to think about it...   It is possible to have LIKE refer to a column for the pattern. This allows you to put the patterns in a table and join to them. You can put you...
12329 Jul 2014 @ 09:10 PDTDatabaseReplyA Sort Table ChangesIf there are equal Prob values, there is no determinism about what order the users will sort. If you need the same rownumber for the same user, you may have to ORDER BY both prob and user.   ...
12229 Jul 2014 @ 07:17 PDTDatabaseReplyIdentify Set - Multiset Tables in TD 14It is much more likely that resources will be consumed by poor choices, or lack of choice, of Primary Index on user created tables. It is worth some education to the users on how to create them app...
12122 Jul 2014 @ 10:10 PDTDatabaseReplyQuery DBC Tables/Columns To Find Empty ColumnsA column is never empty. It always has some defined content. That content might be NULL, it might be a default value specified in the column definition, it might be some default value specified in ...
12021 Jul 2014 @ 03:46 PDTDatabaseReplyUsing MERGE into a table with an identity column. Result: Failure 5758The MINUS operation is a creaative way to eliminate rows that have not changed. However, it breaks the explicit rule for the USING subquery that it must have an explicit equality condition on field...
11921 Jul 2014 @ 02:09 PDTDatabaseReplyIs there any debugger option in Teradata Studio.There is a paragraph titled "Debugging Stored Procedures" in the "SQL Stored Procedures and Embedded SQL" manual in the Teradata documentation set. You have to think about debu...
11817 Jul 2014 @ 05:22 PDTDatabaseReplyGroup by on a Group by not working as expected!!!In addition to agreeing with Ulrich, I also note that you will often get confusing results when you use an alias with the same name as a column which is in the scope of the query - in this case, th...
11715 Jul 2014 @ 01:53 PDTPrivate Forum

Pages