72 | 05 Jun 2014 @ 05:57 PDT | Database | Reply | Schema Slow | Hi
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 ... |
71 | 05 Jun 2014 @ 05:43 PDT | Database | Reply | How to calculate a character occurance in a string in teradata | Hi
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 ... |
70 | 05 Jun 2014 @ 03:18 PDT | Database | Reply | Failure 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
|
69 | 05 Jun 2014 @ 02:54 PDT | Database | Topic | MLPPI 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... |
68 | 04 Jun 2014 @ 11:03 PDT | Database | Reply | Schema Slow | Hi
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... |
67 | 04 Jun 2014 @ 10:50 PDT | Database | Reply | need syntax for for last 2 years data | Hi
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
|
66 | 03 Jun 2014 @ 05:35 PDT | Database | Reply | Use RANK (or other funtion) to number duplicate values in a field, start over with each new field value | Hi
I gave my suggestion based on the sample data above. It is good to hear that it has worked.
Thanks
Santanu
|
65 | 03 Jun 2014 @ 05:27 PDT | Database | Reply | Thoughts 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... |
64 | 01 Jun 2014 @ 11:08 PDT | Database | Reply | How to Choose Columns for JI,CS and PPI | Please 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
... |
63 | 01 Jun 2014 @ 10:56 PDT | Database | Reply | Use RANK (or other funtion) to number duplicate values in a field, start over with each new field value | Hi
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, ... |
62 | 01 Jun 2014 @ 10:37 PDT | Database | Reply | Identifying Single-AMP and All-AMP queries | Hi
You can refer DBQLogTbl and DBQLStepTbl with QueryID and ActiveNumofAMP to find the desired result.
Santanu
|
61 | 25 Apr 2014 @ 05:41 PDT | Database | Reply | Throttle Limits | Hi
This might help.
DBQLogTbl has TDWMRuleID and ProfileID. They can be matched to TDWM.Ruledefs table and DBC.Profiles table.
Thanking You
Santanu
|
60 | 21 Apr 2014 @ 11:33 PDT | General | Reply | Difference between Single Table Join Index, NUSI and Hash Index | yup ... good discussion on HI and STJI ... all consolidated ... :-)
Thanking You
Santanu
|
59 | 21 Apr 2014 @ 01:47 PDT | Database | Reply | Group Concatenate | Hi
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... |
58 | 16 Apr 2014 @ 03:25 PDT | Tools | Reply | fastload error message: Not enough fields in vartext data record number: 1 | Hi
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... |
57 | 16 Apr 2014 @ 01:11 PDT | Database | Reply | Optimizer confidence level and understanding explain plan | Hi
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
|
56 | 14 Apr 2014 @ 05:56 PDT | Database | Reply | Date And Add_Month query problem | Try 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(... |
55 | 04 Apr 2014 @ 03:12 PDT | Tools | Reply | Fast Export and Fast Load Error | That 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
|
54 | 02 Apr 2014 @ 06:03 PDT | Tools | Reply | Fast Export and Fast Load Error | Please 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
|
53 | 02 Apr 2014 @ 05:41 PDT | Database | Reply | Volatile 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... |
52 | 31 Mar 2014 @ 03:45 PDT | Database | Topic | Capacity 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... |
51 | 31 Mar 2014 @ 03:41 PDT | Tools | Reply | BTEQ Import Invalid Date Issue | Hi 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 ... |
50 | 07 Mar 2014 @ 04:41 PST | Database | Reply | Getting error while copying data from one temporal table to other temporal table | Hi
Did you have any join index defined on the source table ?
Thanking You
Santanu
|
49 | 07 Mar 2014 @ 04:35 PST | Database | Reply | finding 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
|
48 | 06 Mar 2014 @ 10:54 PST | Database | Reply | Getting error while copying data from one temporal table to other temporal table | Hi
Try this.
CREATE MULTISET TABLE XXX.COPY AS XXX.MAIN WITH DATA AND STATS ;
Please let know the result
Thanking You
Santanu
|