All forum activity

#DateUserForumTypeThreadPost
4642828 Nov 2014 @ 02:24 PSTps.suma@gmail.comDatabaseTopicHelp with SQL: redistributing dataHi, I am working on a query to combine multiple rows with overlapping dates for the same information. I use partition by and reset when to achieve this. However, even though the table has primary...
4642728 Nov 2014 @ 10:09 PSTBlaineKinnebrewDatabaseReplyExecute permissionDieter, Thank you! Blaine
4642628 Nov 2014 @ 06:20 PSTVandeBergBDatabaseReplyFast Load - doesn't load duplicate records in multi set tableBy default, FastLoad eliminates duplicate records.  The entire row must be a duplicate, not just the PI, the entire row.  There is no way to retrieve the duplicate discards.   
4642528 Nov 2014 @ 05:44 PSTjacek.adamowiczToolsReplyTPT SelectStmtHi, I'm using TPT 14.00.00.03, both on Windows and AIX. I am exporting data using $EXPORT template. It seems that escaping single quotes by doubling them does not work for SelectStmt. I am no...
4642428 Nov 2014 @ 02:00 PSTratchetandclankToolsReplyTPT Vs other ETL Utilitiesvincent91, Please check "-h" option in the TPT.
4642327 Nov 2014 @ 11:58 PSTHarpreet SinghDatabaseReplyFast Load - doesn't load duplicate records in multi set tableHi, Please refer http://forums.teradata.com/forum/tools/why-mload-accepts-duplicates-and-why-dont-fastload.
4642227 Nov 2014 @ 11:34 PSTDSDatabaseTopicFast Load - doesn't load duplicate records in multi set tableHi All, Want to know why fast load do not load duplicate records in multiset table. Please give me the reason behind such behaviour    Thanks, DS  
4642127 Nov 2014 @ 04:32 PSTSikeeGeneralTopicWrite TPT with JCLHi Guys, Can you please help with writing TPT Script with JCL. I have written a TPT script and want to embed it in JCL (Job control language) for mainframe. I have no idea how to do this. If I can...
4642027 Nov 2014 @ 01:18 PSThema.ananthToolsTopicTeradata Utilities installationHi All,   I have installed Teradata Express VMware. Able to connect to the DB using bteq and SQL Assistant.   Now Trying to install Teradata utilities (Windows Client installation Pac...
4641926 Nov 2014 @ 11:28 PSTHarpreet SinghDatabaseReplyHow to decide about Stats for new queriesNo you cannot check from view directly. 
4641826 Nov 2014 @ 11:24 PSTHarpreet SinghDatabaseReplyTimestamp and date calculationThanks Dieter.
4641726 Nov 2014 @ 08:49 PSTamaduDatabaseReplycopy/backup table Hi Ulrich -  Yes its on the same server. Thank you for your help. Alls good with your help.
4641626 Nov 2014 @ 06:48 PSTvarnasDatabaseTopicTeradata 14 certification HelpHi, I am planning to write Teradata 14 certifications. Can any one suggest me which materials are good to study. I am planning to write first 3 exams in next month.  Please guide me if you kn...
4641526 Nov 2014 @ 06:30 PSTGianTDDatabaseReplyIdentify the queriesI use ODBC.   Query band worked fine, Thanks ! Ulrich. That solved my purpose.   Comment thing i wanted to check just in case...    
4641426 Nov 2014 @ 06:07 PSTGianTDDatabaseReplyHow to decide about Stats for new queriesRight Harpreet but my question was: To check about the existing stats on the tables... - Can we check from views itself used in the query? (As you need to check definition of each view to find ...
4641326 Nov 2014 @ 03:41 PSTSteveBovyToolsReplyTTP output file not getting zipped when .gz is used as file extensionThe zip/gzip support was added to 13.10 in efix 08. Their were some additional fixes in efix 020.   Please upgrade to the currentlatest 13.1o efix.   Thanks  
4641226 Nov 2014 @ 02:11 PSTyuvanaDatabaseTopiccan a Stored procedure can load the data from one view to another view.?Hi Can any one confirm me,  1. Is A Stored procedure can load the data from one View to Another VIew? 2. is A stored procedure can load the data from one Table to anothe VIew? 3. Is Stored...
4641126 Nov 2014 @ 11:24 PSTssurajssAsterReplyConnectivity between Aster 6.0 and HDP 2.1Hi Aastha, Even i am facing the same error. Were you able to resolve this issue ?  
4641026 Nov 2014 @ 09:19 PSTmathanur5ToolsTopicTTP output file not getting zipped when .gz is used as file extensionHello All, We are trying to create a zipped text file extract from a Teradata table using TPT script. We have named the file as <file_name>.dat.gz but for some strange reasons the out file d...
4640926 Nov 2014 @ 08:19 PSTstahengikDatabaseTopicImport data from SAS using Teradata SQL AssistantHi, We have data in SAS server and we need to get some tables in teradata.  The way we are doing it now is using SAS to write data in teradata database, I want to know if there is way by whi...
4640826 Nov 2014 @ 06:18 PSTfirstjDatabaseTopicc / END TRANSACTION - Max. number of statementsCan anyone confirm the max. number of SQL statements that can be run between BT; / ET; statements when running in Teradata V14?   Thanks
4640726 Nov 2014 @ 06:05 PSThazard01DatabaseReplyselect value from string with varying positionHi there, I am using version 14 so I will give it a try shortly and let you know.  That's a new one on me so thanks for the heads up.   Mike
4640626 Nov 2014 @ 05:24 PSTJugalkishorebhatt1DatabaseTopicJOIN INDEXES WITH PRIMARY INDEXHello All,   Why we cannot have JOIN INDEXES with UPI/USI. If there is a option to create a Join Indexes with UPI/USI, how can it be done.   Thanks Jugal
4640526 Nov 2014 @ 04:21 PSTdnoethTeradata StudioReplyIncrease Java Heap space in OSX Express Studio? On OSX the ini file is in the application folder: control click on the application and choose "Show Package Contents" in the context menu.   Then it's in the MacOs folder (you ...
4640426 Nov 2014 @ 04:02 PSTdnoethDatabaseReplyTeradata Pivot Is there Seq_nbr guaranteed to be always in the correct order: 1,2,1,2,1,2,...? SELECT EMP_ID,Date,Seq_nbr, Punch AS Punch_in, MIN(Punch) -- next value OVER (PARTITION BY EMP_I...

Pages