|31890||20 May 2013 @ 05:29 PDT||ronirwin||Database||Reply||SUBSTR without explicitly coding the length parm||Thanks for the explanation
|31889||20 May 2013 @ 03:33 PDT||sahilchaudhry08||Tools||Topic||TPT: Moving tables from One TD box to other TD box using TPT ||Hi I am new to thi forum . I am in urgent need to know. I have 2 teradata boxes example 6700 and 1690 whether I can write a TPT script to transfer whole table with data from 6700 TD box to 169... |
|31888||20 May 2013 @ 02:03 PDT||sureshv||Database||Reply||tuning the Skewed joins||Hi Dieter,
Thanks for the reply. I tried with the above union all . the cost is somewhat reduced. but the problem is in the query i have 2 INNER JOINS with this type of skewed column on si... |
|31887||19 May 2013 @ 11:57 PDT||oracle.bhadram||Training||Reply||Online Training||Hi friends,
This is my first online training experience , which I would like to share with you all. I have my own doubts about the training, trainer and material. The few sessions I went through, ... |
|31886||19 May 2013 @ 09:40 PDT||teradatauser2||Viewpoint||Reply||Canary Query Details||Hi,
I want ti run a macro - PDCRINFO.CapCanarySUMRT_Rpt. This macro will give me max and avg canary response time. I see that this macro uses PDCRDATA."Canary_Hst" and PDCRDATA."Shi... |
|31885||19 May 2013 @ 06:00 PDT||ysdevi||Training||Reply||Teradata DBA Traninig in Hyderabad?||Hi,
I joined for May2013 batch for teradata online Training(Developer track) from Manohar(email@example.com) of BISP.He is
technically sound and explains concepts very clearl... |
|31884||19 May 2013 @ 10:13 PDT||Dolm||Database||Reply||Average of volume by weekday and hour over range||Thank you Dieter! I wound up using the calendar to divide by the the number of days in the date range, rather than only days with data. You've helped me tremendously!
|31883||19 May 2013 @ 08:53 PDT||kk_newuser||Tools||Reply||SQL_ASSISTANT "Error executing query for record 1: 22001: Character string truncated"||HI
as error message indicates "Character string truncated" ...
your data is too large then the column length. Remove the junk characters from data file.
|31882||19 May 2013 @ 02:05 PDT||Fractals||Tools||Topic||Statistics collection||I have few doubts regarding statistics collection.
1. Does the order of columns used in collect stats command important?
2. Consider the following scenario
Table A jo... |
|31881||18 May 2013 @ 07:48 PDT||Varun.k||General||Reply||Informatica TPT issue||Hi Jigar,
while useing TPT through informatica i will create two error table
Error table-1 will have information about any error tada or rejected data.
|31880||18 May 2013 @ 01:13 PDT||Private Forum |
|31879||18 May 2013 @ 10:48 PDT||dnoeth||Database||Reply||Average of volume by weekday and hour over range||You group both times by the same columns, if i understodd you correctly you have to group by date/hour first and then by weekday:
creation_dt (FORMAT 'eee') (CHAR(3))
|31878||18 May 2013 @ 10:16 PDT||Dolm||Database||Topic||Average of volume by weekday and hour over range||
I'm trying to calculate the average number of calls for a given weekday by hour of the day. I've tried nesting aggregates byt it always comes out to 1, rather than the actual ... |
|31877||18 May 2013 @ 03:18 PDT||siya||Training||Reply||Hadoop Training@ Intellipaat,9019368913||i am interested in Hadoop Training... please drop a mail with details at firstname.lastname@example.org.
|31876||17 May 2013 @ 10:06 PDT||Smarter_teradata||Database||Topic||2644 - not recorded in DBQL||Hi All,
Recently one of our fastload job got failed with the error "no more room in databae" but it was found that there is no entry in the dbql tables for the above failur... |
|31875||17 May 2013 @ 04:11 PDT||TonyL||Tools||Reply||TPT: system variables with result count||System variables have not been added to the TPT product yet. We are planning to add the system variables in the TPT 15.00 release.
|31874||17 May 2013 @ 03:55 PDT||Fred||Database||Reply||calling a SP inside a SP.||See the explanation and chart in the DDL manual under CREATE PROCEDURE regarding which user's and/or database's rights are checked with different SQL SECURITY options. For this case sp... |
|31873||17 May 2013 @ 03:15 PDT||pawankumarjha||Database||Topic||DDL/DML Version Control||Hi Teradata Gurus,
I am relatively new to Teradata and using Teradata ver 13 SQL assistant. I need to verify from the experts whether there is any version control in place in Teradata for the code... |
|31872||17 May 2013 @ 12:39 PDT||abhishek.jadhav||Database||Reply||DATABASE BACKUP||I believe there is no table which will directly give you list of tables/databases which are not archived.
However you can use dbc.events ,which stores information of all ARC activity which took pl... |
|31871||17 May 2013 @ 11:55 PDT||Teradata_Eric||Connectivity||Topic||Data not formatted when linked to Excel||I connected Excel to my Teradata table and I get all of my data but every other row in my data set under one column of data, TIME1, is 0:00 instead of an actual time like 8:00. My data table i... |
|31870||17 May 2013 @ 11:47 PDT||fgrimmer||Teradata Studio||Reply||TD studio does not reflect DDL changes.||You do not need to close and reopen Studio but simply do a "Refresh" of the folder in the Data Source Explorer (DSE), if you have created objects by entering the DDL in the SQL Editor. If... |
|31869||17 May 2013 @ 10:34 PDT||acire818||Database||Reply||Returning a Results from Stored Procedure||Thanks so much. That gave me the results I was looking for.
|31868||17 May 2013 @ 08:02 PDT||gryback||Viewpoint||Reply||SQL and Explain sometimes not visible in query monitor||What version of Viewpoint?
|31867||17 May 2013 @ 08:00 PDT||gryback||Viewpoint||Reply||Viewpoint initiation: creation of multiple users||To see their own queries, they should be using the My Queries portlet. If you want a group of users to see each others queries but not all queries on the system, then you should setup a Query Group... |
|31866||17 May 2013 @ 07:54 PDT||gryback||Viewpoint||Reply||Password Age Alerting via Viewpoint Portlet||Nothing currently planned with Viewpoint in this area of Teradata login/password management. Why wouldn't this be a feature request on the database than?