#DateForumTypeThreadPost
7205 Jun 2014 @ 05:57 PDTDatabaseReplySchema SlowHi Again there may be various reasons why system is slow. If you have viewpoint then check system health portlet, matric analysis protlet, query monitor portlet to get specific idea. Also you can ...
7105 Jun 2014 @ 05:43 PDTDatabaseReplyHow to calculate a character occurance in a string in teradataHi  If you are using TD 14 or higher then you can use below code snippet as reference, where column C1 will hold the intended value.   WITH RECURSIVE SPLIT_DATA(MAIN , SUB , COUNTS ...
7005 Jun 2014 @ 03:18 PDTDatabaseReplyFailure 2673 The source parcel length does not match data that was defined.Hi Try below and reply whether it has worked. remove filler (char(1)) change reslt varchar(11) in table   Thanks Santanu
6905 Jun 2014 @ 02:54 PDTDatabaseTopicMLPPI Constraint Explanation Hi All   If a table is defined as MLPPI the constraint can be checked either from DBC.PartitioningConstraintsV or from DBC.IndexConstraintsV.  There the ConstraintText feil...
6804 Jun 2014 @ 11:03 PDTDatabaseReplySchema SlowHi spool space is the unused perm space, there can be many reasons behind the spool space issue. Please check whether the user submitting the queries has enough spool space limit assigned. Also ch...
6704 Jun 2014 @ 10:50 PDTDatabaseReplyneed syntax for for last 2 years dataHi I am assuming the businessdate field has data type 'Date'. If so then you can use below, where businessdate between (date - interval '2' year) and date Thanks Santanu
6603 Jun 2014 @ 05:35 PDTDatabaseReplyUse RANK (or other funtion) to number duplicate values in a field, start over with each new field valueHi   I gave my suggestion based on the sample data above. It is good to hear that it has worked.   Thanks Santanu
6503 Jun 2014 @ 05:27 PDTDatabaseReplyThoughts on CPUBusy caclulations.Hi All One quick question. What does the below query signify in terms of user cpu calculation? I know it is different than the above CPUUEXEC calculation from resusagespma table.   SELECT t...
6401 Jun 2014 @ 11:08 PDTDatabaseReplyHow to Choose Columns for JI,CS and PPIPlease go through the below link. They will definitely give you answers. http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Storage_Management/B035_2503_071A/2503ch05.066.04.html ...
6301 Jun 2014 @ 10:56 PDTDatabaseReplyUse RANK (or other funtion) to number duplicate values in a field, start over with each new field valueHi Try the below query, hope this will work. SEL ID, NAME , NAME||'-00'||TRIM(ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ID)) AS NAME_RANK FROM DB_NAME.TABLE_NAME ORDER BY ID, ...
6201 Jun 2014 @ 10:37 PDTDatabaseReplyIdentifying Single-AMP and All-AMP queriesHi You can refer DBQLogTbl and DBQLStepTbl with QueryID and ActiveNumofAMP to find the desired result. Santanu
6125 Apr 2014 @ 05:41 PDTDatabaseReplyThrottle LimitsHi This might help.  DBQLogTbl has TDWMRuleID and ProfileID. They can be matched to TDWM.Ruledefs table and DBC.Profiles table. Thanking You Santanu
6021 Apr 2014 @ 11:33 PDTGeneralReplyDifference between Single Table Join Index, NUSI and Hash Index yup ... good discussion on HI and STJI ... all consolidated ... :-)   Thanking You Santanu
5921 Apr 2014 @ 01:47 PDTDatabaseReplyGroup ConcatenateHi  Try below.   WITH RECURSIVE TESTING (ID, RANKS, TEXTS) AS ( SELECT ID, RANKS, CAST(TEXTS AS VARCHAR(50)) AS TEXTS FROM TABLE1 WHERE RANKS = 1   UNIO...
5816 Apr 2014 @ 03:25 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1Hi Do you have TPT 14 as part of TTU package in Linux system? Then you can use Dataconnector Producer operator with "QuotedData" option and then run Load operator as fast load. This will...
5716 Apr 2014 @ 01:11 PDTDatabaseReplyOptimizer confidence level and understanding explain planHi If you are joining both the tables, kindly share the query. Also share the collect stats statements you executed and if possible the entire explain plan. Thanking You Santanu
5614 Apr 2014 @ 05:56 PDTDatabaseReplyDate And Add_Month query problemTry below SEL TO_CHAR((CURRENT_DATE - 7), 'DD-MON-YYYY') || '|' || TO_CHAR(LAST_DAY(ADD_MONTHS(CURRENT_DATE, 11)), 'DD-MON-YYYY') ;   SEL TO_CHAR(TO_DATE(&#...
5504 Apr 2014 @ 03:12 PDTToolsReplyFast Export and Fast Load ErrorThat is right Jugalkis, it should be fixed length data type. I had SET RECORD VARTEXT in my mind while typing my response. My bad. :-) Thanking You Santanu
5402 Apr 2014 @ 06:03 PDTToolsReplyFast Export and Fast Load ErrorPlease create the table within your fastload script with Varchar columns and then try loading, else you can try using TPT Load operator. Thanking You Santanu
5302 Apr 2014 @ 05:41 PDTDatabaseReplyVolatile table vs views.Hi Prateek Let me try to answer your question. Volatile table and views they are different by nature. Volatile tables are session specific, they use spool space from user. So with different useri...
5231 Mar 2014 @ 03:45 PDTDatabaseTopicCapacity Planning and Dictionary Tables and Views Hello Everyone,   I have read that DBQL and ResUsageS tables, views and macros are important for system capacity planning. For example ResUsageSpma and ResNode. But what about the o...
5131 Mar 2014 @ 03:41 PDTToolsReplyBTEQ Import Invalid Date IssueHi Tarun Try using below. SEL  CAST(CAST( SUBSTR('Mar 14 2007 12:00:00:000AM', 1, 11) AS VARCHAR(11)) AS DATE FORMAT'MMMBDDBYYYY') ;   But still using so many casting ...
5007 Mar 2014 @ 04:41 PSTDatabaseReplyGetting error while copying data from one temporal table to other temporal tableHi   Did you have any join index defined on the source table ? Thanking You Santanu
4907 Mar 2014 @ 04:35 PSTDatabaseReplyfinding links between two col values..Hi In my understanding you trying to find the parent-child relation. Look for Recursive Query (using Level in Root). Thanking You Santanu
4806 Mar 2014 @ 10:54 PSTDatabaseReplyGetting error while copying data from one temporal table to other temporal tableHi Try this. CREATE MULTISET TABLE XXX.COPY AS XXX.MAIN WITH DATA AND STATS ; Please let know the result   Thanking You Santanu

Pages