All forum activity

#DateUserForumTypeThreadPost
4755927 Jan 2015 @ 09:57 PSTShoushounetteGeneralReplySubstring/Trim i can trim the first part till ] with : SUBSTR(col1,INDEX (col1,']')+1) which it gives 'Ipad Mini on line' but i cannot cut the last part 'on line' of the column.
4755827 Jan 2015 @ 09:12 PSTravi.aysolaDatabaseReplyHow to Enable Temporal Feature Thanks Dieter
4755727 Jan 2015 @ 08:18 PSTShoushounetteGeneralTopicSubstring/TrimHi Leaders, I got confused how i use substring and trim to get some data, here an example: Col1                             &...
4755627 Jan 2015 @ 07:57 PSTanilrajuTrainingReplyTeradata DBA Traninig in Hyderabad?Hello Friends, I have asked int this forum and discussed with many in the Online and Offline market, finally I joined in Vinay Tech Institite for DBA in hyderabad. He explored about various ki...
4755527 Jan 2015 @ 07:52 PSTanilrajuTrainingReplyAny best Training Centres you guys know in Hyderabad??Hello Friends, I have asked int this forum and discussed with many in the Online and Offline market, finally I joined in Vinay Institite hyderabad.   Thanks to everyone for thier valuable ...
4755427 Jan 2015 @ 07:15 PSTToddAWalterDatabaseReplySkew Factor & StatsSkew should not be considered important for any object smaller than a few data blocks per AMP. There is just not enough statistical distribution to get an even distribution. And skew for very small...
4755327 Jan 2015 @ 07:07 PSTShayneToolsTopicTDA connectionhi dnoeth, it is so wired , i could use my TDA to connect my ODBC . I can't do it today; I did like usually, open the VM, use /etc/init.d/ tpa start and then tpestate -a; bteq logon  sec...
4755227 Jan 2015 @ 06:33 PSTwsiplDatabaseTopic2642 - AMP Down on Teradata Express VMWARE.Hello,  We have an error on VMWARE machine with AMP down and the queries giving us 2642. The queries on dbc work fine but they give 2642 on other user tables.     Cleared&nbs...
4755127 Jan 2015 @ 05:25 PSTjohnsunnydewDatabaseReplySkew Factor & StatsHia thanks Raja..One more question..I am querying on a database to find the skeness of all tables..The result shows me including that of the stored procedures too and all stored procedures shows sk...
4755027 Jan 2015 @ 02:51 PSTRaja_KTDatabaseReplySkew Factor & StatsYou dont need to refresh. I think you come from Oracle background, where you see materialized view, where  you can refresh.
4754927 Jan 2015 @ 02:14 PSTjohnsunnydewDatabaseTopicView refresh after collect statsHi, Lets say am collecting stats for a table and once when i have done that, do i need to refresh its corresponding view?   Regards Sunny
4754827 Jan 2015 @ 01:50 PSTjohnsunnydewDatabaseReplySkew Factor & StatstHANKS. One quick question..do we need to refresh a view once we collect stats for its underlying table?
4754726 Jan 2015 @ 11:23 PSTSHERIN JEYABOSEDatabaseTopicBest file format supported by Teradata - FASTLOAD What is the best file format which supports fastload ? There are various...but would like to know the best file format when connected with LINUX - a fastload supports ef...
4754626 Jan 2015 @ 11:21 PSTRaja_KTDatabaseReplySkew Factor & StatsHi, You can have a look at this link(look till the end):  http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch09.050.139.html One way ...
4754526 Jan 2015 @ 11:09 PSTMarcodv1DatabaseTopicDrop Error: Falied 3932Hi All,   Executing SQL statement like Drop error table for TableX; Alter TableX Add COLUMN_NAME varchar(20); Results in an error: Drop Error: Falied 3932: Only an ET or null state...
4754426 Jan 2015 @ 10:07 PSTjohnsunnydewDatabaseTopicSkew Factor & StatsHi, I am quite new here to Teradata...Can anyone help me onthe query.. I am looking out for skew factors for certain tables.I would like to know the query for the same and what would be the desire...
4754326 Jan 2015 @ 10:05 PSTRaja_KTDatabaseReplykeep the data last recod of the grouppI am assuming that the ones in bold are the required (ones). How do you get the 5,6 lines. I am thinking that the 6th line is 123 abc 2014 5000. Try something thus: select Mbr_num,...
4754226 Jan 2015 @ 09:27 PSTRaja_KTGeneralReplyRestore the loaded source data files in backup folderAre you using Susie Linux? See if you can run upstream jobs to reproduce the files. Talk to  Unix/Linux admin to recover the files. eg:With debugfs , inode, you may get back .
4754126 Jan 2015 @ 04:24 PSTfgrimmerTeradata StudioReplyJRE 8.1.31 not recognized on TD Studio Express InstallationLeslie, Studio Express does not yet support JRE 1.8. Only 1.6 and 1.7 at this time.
4754026 Jan 2015 @ 03:34 PSTJay2014DatabaseReplykeep the data last recod of the grouppPlease help me on this !!
4753926 Jan 2015 @ 01:48 PSTLS186001Teradata StudioTopicJRE 8.1.31 not recognized on TD Studio Express InstallationI am trying to install the latest version of TD Studio Express on my Win7 machine. I have 64-bit JRE 8.1.0_31 installed but I keep getting the message that JRE 1.6 or above is required. How do I ge...
4753826 Jan 2015 @ 01:29 PSTdavid.craigDatabaseReplyCast VARCHAR to INTEGER works The embedded dashes are allowed unless the number is signed. The comma is allowed because it probably is the GroupSeparator in the SDF. For more details on the parsing rules, see the charac...
4753726 Jan 2015 @ 12:32 PSTDiecorpDatabaseTopicCast VARCHAR to INTEGER worksHi... I'm running this query:  SEL CAST(CAST('99--,-25--1'AS VARCHAR(15)) AS INTEGER) I would hope that the query fails, but it works, the resulset is: 99251.   I'm w...
4753626 Jan 2015 @ 11:23 PSTJay2014DatabaseTopickeep the data last recod of the grouppI am trying to keep value at end of the group rest of the values should be null in the group. Input data Mbr_num  class_nmae year  Member_total 123      &...
4753526 Jan 2015 @ 10:53 PSTivanrinoDatabaseReplyMissing/Invalid SQL statement'E(3707):Syntax error, expected something like ';'Excellent.. Ths

Pages