|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 email@example.com.
|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?
|31865||17 May 2013 @ 04:39 PDT||dnoeth||General||Reply||Reg.Teradata Features||For each release there's a Release Summary with all the new features:
|31864||17 May 2013 @ 04:26 PDT||Anandhi Palanisamy||General||Topic||Reg.Teradata Features||Hi,
I am new to Teradata, could anyone list the difference between Teradata 13.10 and Teradata 14 and new features which are avaialble in Teradata 14.
Thanks in Advance.
|31863||17 May 2013 @ 04:21 PDT||dnboa||Database||Topic||First connection teradata 14 after installation||Hi,
I installed/configured teradata 14 .
I can logon with bteq :
*** Logon successfully completed.
*** Teradata Database Release is 14.00.02.05
*** Teradata Database Vers... |
|31862||17 May 2013 @ 03:32 PDT||Qaisar Aftab Kiani||Database||Reply||volatile table as select..with data - not loading data||ON COMMIT DELETE ROWS is the default option set with volatile table syntax. You can mention that explicitly as well, but if you specify this option then you will loose the data as soon as the trans... |
|31861||17 May 2013 @ 02:45 PDT||Qaisar Aftab Kiani||Database||Reply||Oracle "REPLACE" function equivalant function in Teradata||Teradata now provides the OREPLACE function bydefault, so why not use that?
|31860||17 May 2013 @ 02:20 PDT||paulxia39||Database||Reply||volatile table as select..with data - not loading data||hello,dieter:
Where we can use 'on commit delete rows'option?I haven't use this options until now.