#DateForumTypeThreadPost
10017 Mar 2014 @ 11:28 PDTAsterReplyReplace all characters in string except particular wordsI have not used database regex_replace, but using any regex function I think you could embded a series to incrementtally replace.   1. Replace Jakarta with a single char - say "+" ...
9905 Sep 2013 @ 10:33 PDTPrivate Forum
9815 Jul 2013 @ 11:17 PDTDatabaseReplyComposite Secondary Index-Nishant have you read this blog on SI? http://developer.teradata.com/database/articles/indexes-too-much-of-a-good-thing
9715 Jul 2013 @ 10:51 PDTDatabaseReplyComposite Secondary Index-There is no way to guess which is better -  you will need to experiment. Try both single and two col index.  Review the EXPLAIN plan for both. Compare the performance of no SI, singl...
9615 Jul 2013 @ 10:08 PDTDatabaseReplyComposite Secondary Index-Generally, the individual indices would be helpful for access and the optimizer might be able to do a bit map with them if they are weakly selective alone. The 1 or 2 col index would be used ...
9515 Jul 2013 @ 08:43 PDTDatabaseReplyno data condition with dynamic result setDid some testing and the NOT FOUND handler does not trigger for a dynamic result set. When the NOT FOUND handler is removed then the update returns a run time error: invalid stateme...
9412 Jul 2013 @ 11:02 PDTDatabaseTopicno data condition with dynamic result set  Anybody know how to detect NO DATA condition for a select in dynamic result set?     This simple example detects the no condition  for the UPDATE but  the sel...
9314 Feb 2012 @ 02:52 PSTToolsReplyTPT script loading issue I am getting similar error but is not related to invalid data.      When using load operater to MULTISET NOPI  all rows load.  When using load operator...
9217 Jan 2009 @ 06:05 PSTToolsReplyHow to return BTEQ and Fastload error codes to UnixCheck you logic the if then fi should enclose the fail messagefastload<xif (($? != 0))then echo failelse echo okfi
9128 Aug 2008 @ 07:41 PDTToolsReplyFile record number in mloadThis was not a wise guy answer. Thanks for the wonderful feed back.
9027 Aug 2008 @ 04:25 PDTDatabaseReplyCan You Limit Number of Sessions Per User ?Also in v2r5 there was Teradata DQM Administrator (which in v2r6 was renamed the Teradata DWM. DQM will allow you to limit the limit the number of logons and the number of running queries for s...
8927 Aug 2008 @ 03:49 PDTDatabaseReplyCan You Limit Number of Sessions Per User ?Have you investigated using priority scheduler? This allows you to place a ceiling on the amount of resources an application can have. Suggest you carefully read the "Teradata Performance Optimiz...
8827 Aug 2008 @ 09:48 PDTToolsReplyFile record number in mloadUse an IDENTITY column:http://www.teradataforum.com/teradata/20040526_023940.htm
8725 Aug 2008 @ 02:30 PDTUDAReplyTPT performanceParallelism is increased over the traditional database parallelism by using file streams as opposed to writing to disk. This allows each data stream to be shared with multiple instances of each ope...
8625 Aug 2008 @ 07:33 PDTToolsReplySQL Right Justify columnThe CHAR cast is not needed. Just use the format: SAUP (FORMAT 'ZZ,ZZZ,ZZ9.99' (NAMED VALUE1), If you are exporting using FastExport this will not work unless you specifiy format TEXT in the expo...
8525 Aug 2008 @ 07:29 PDTToolsReplyMultiload cannot be appilied on tables with USIYou should download the complete set of Teradata documentation from this website.
8418 Aug 2008 @ 09:30 PDTAnalyticsReplyGroup By and many columnsIf you just want unique values you can use DISTINCT, but this can have slower performance than the group by. You can also use ordered analytical functions in place of the group by otherwise the an...
8321 Jul 2008 @ 08:06 PDTToolsReplyError with Fastloaddid you include a new-line at the end of the single record? In other words:12345
8221 Jul 2008 @ 07:58 PDTToolsReplyUsing environment variable in mload scriptYou are trying to use Unix variables in a Teradata utility.To accomplish this you have to interpret the script through the ksh. For example:mload<<eof.logtable $MYLOGTABLE;.logon $MYTDP/$MYI...
8121 Jul 2008 @ 07:54 PDTDatabaseReplyImplementing Fallback....Being unfamiliar with your system I am curious why you ARE using fallback? You did not say if fallback will be applied to all your tables or only a few tables. Generally, fallback is usually on...
8018 Jul 2008 @ 09:01 PDTDatabaseReplyCounting Record From Source FileSince you have many tables with the same column name, this is the only way you can count the rows in a table. You could review the load logs (if there are any) and extract the rows loaded.
7918 Jul 2008 @ 08:59 PDTToolsReplyMultiload using two source filesYou can do it using any of these methods:1. Use Teradata Parallel Transporter (TPT). 2. Run the mload twice. First on one file then on the other.3. Combine the files and run mload.4. Create a name...
7818 Jul 2008 @ 08:56 PDTAnalyticsReply2651: Operation Error computing expression involvingAccording to the Error message manual:2651 Operation Error computing expressioninvolving %TVMID.%FLDID.Explanation: This error occurs only when thenumeric co-processor returns an operand error. Thi...
7716 Jul 2008 @ 03:45 PDTToolsReplyERROR Loading Pipe delimited file thorugh MLOADFirst, I think you should be careful to always remove your id and password when sharing scripts.1. If the first record fails but all the other records are ok then there may be some unprintable char...
7615 Jul 2008 @ 02:27 PDTDatabaseReplyOrder of WHERE clause conditionsYou can always see exactly how the optimizer will execute your sql by running the EXPLAIN plan. If the variations of sql produce the same EXPLAIN then there will be no difference in performance.

Pages