All forum activity

#DateUserForumTypeThreadPost
3188419 May 2013 @ 10:13 PDTDolmDatabaseReplyAverage of volume by weekday and hour over rangeThank 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!   SELECT dt.dayo...
3188319 May 2013 @ 08:53 PDTkk_newuserToolsReplySQL_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.   Regards Kartheek
3188219 May 2013 @ 02:05 PDTFractalsToolsTopicStatistics collectionI 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...
3188118 May 2013 @ 07:48 PDTVarun.kGeneralReplyInformatica TPT issueHi Jigar, while useing TPT through informatica i will create two error table  like Erro_table-1,Error_table-2, Error table-1 will have information about any error tada or rejected data. Er...
3188018 May 2013 @ 01:13 PDTPrivate Forum
3187918 May 2013 @ 10:48 PDTdnoethDatabaseReplyAverage of volume by weekday and hour over rangeYou group both times by the same columns, if i understodd you correctly you have to group by date/hour first and then by weekday: SELECT creation_dt (FORMAT 'eee') (CHAR(3)) ,AV...
3187818 May 2013 @ 10:16 PDTDolmDatabaseTopicAverage 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 ...
3187718 May 2013 @ 03:18 PDTsiyaTrainingReplyHadoop Training@ Intellipaat,9019368913i am interested in Hadoop Training... please drop a mail with details at sima.saxena@yahoo.in.
3187617 May 2013 @ 10:06 PDTSmarter_teradataDatabaseTopic2644 - not recorded in DBQLHi 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...
3187517 May 2013 @ 04:11 PDTTonyLToolsReplyTPT: system variables with result countSystem variables have not been added to the TPT product yet. We are planning to add the system variables in the TPT 15.00 release.
3187417 May 2013 @ 03:55 PDTFredDatabaseReplycalling 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...
3187317 May 2013 @ 03:15 PDTpawankumarjhaDatabaseTopicDDL/DML Version ControlHi 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...
3187217 May 2013 @ 12:39 PDTabhishek.jadhavDatabaseReplyDATABASE BACKUPI 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...
3187117 May 2013 @ 11:55 PDTTeradata_EricConnectivityTopicData not formatted when linked to ExcelI 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...
3187017 May 2013 @ 11:47 PDTfgrimmerTeradata StudioReplyTD 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...
3186917 May 2013 @ 10:34 PDTacire818DatabaseReplyReturning a Results from Stored ProcedureThanks so much.  That gave me the results I was looking for.
3186817 May 2013 @ 08:02 PDTgrybackViewpointReplySQL and Explain sometimes not visible in query monitorWhat version of Viewpoint? 
3186717 May 2013 @ 08:00 PDTgrybackViewpointReplyViewpoint initiation: creation of multiple usersTo 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...
3186617 May 2013 @ 07:54 PDTgrybackViewpointReplyPassword Age Alerting via Viewpoint PortletNothing currently planned with Viewpoint in this area of Teradata login/password management. Why wouldn't this be a feature request on the database than? 
3186517 May 2013 @ 04:39 PDTdnoethGeneralReplyReg.Teradata FeaturesFor each release there's a Release Summary with all the new features: http://www.info.teradata.com/edownload.cfm?itemid=113480006   Dieter
3186417 May 2013 @ 04:26 PDTAnandhi PalanisamyGeneralTopicReg.Teradata FeaturesHi, 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.
3186317 May 2013 @ 04:21 PDTdnboaDatabaseTopicFirst connection teradata 14 after installationHi,   I installed/configured teradata 14 . I can logon with bteq : *** Logon successfully completed.  *** Teradata Database Release is 14.00.02.05  *** Teradata Database Vers...
3186217 May 2013 @ 03:32 PDTQaisar Aftab KianiDatabaseReplyvolatile table as select..with data - not loading dataON 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...
3186117 May 2013 @ 02:45 PDTQaisar Aftab KianiDatabaseReplyOracle "REPLACE" function equivalant function in TeradataTeradata now provides the OREPLACE function bydefault, so why not use that?
3186017 May 2013 @ 02:20 PDTpaulxia39DatabaseReplyvolatile table as select..with data - not loading datahello,dieter: Where we can use 'on commit delete rows'option?I haven't use this options until now.

Pages