All forum activity

#DateUserForumTypeThreadPost
2761404 Oct 2012 @ 07:51 PDTKoushik ChandraGeneralTopicServer configuration for TDE 13.10.00.10 for VM Ware (1 TB) installationHi, Can any one please let me know the configuration required for a Linux VM Ware server for "TDE 13.10.00.10 for VM Ware (1 TB)" installation, considering approximately 100 concurrent u...
2761304 Oct 2012 @ 06:41 PDTrobpallerDatabaseReplySQL to find Row CountNo. DBQL doesn't seem to log records inserted, deleted, or updated by INSERT, UPDATE, DELETE, or MERGE operations. Do you have any timestamp or date fields on the table to track when records h...
2761204 Oct 2012 @ 02:51 PDTcarrieViewpointReplyViewpoint / Workload Monitor Dynamic Pipes View.This question was also posted on my blog on Dev X.  Here is the response I gave at that location: A query is not allocated to a resource partition directly. It is mapped to a performance grou...
2761104 Oct 2012 @ 01:53 PDTchand308DatabaseTopicSQL to find Row CountHi,   I am trying to find if there is any way we can find the record count of queries that logged into DBQL with Insert or Update statement types. I tring to see the row count by taking the ...
2761004 Oct 2012 @ 01:40 PDTQaisar Aftab KianiDatabaseReplyHow to force duplication of the rows from a small table on all AMPsHi Ayush, In that case the join will cost more as you are joining two non-index columns. TD will be redistributing the data for both of the tables on the joining columns to make sure that the data...
2760904 Oct 2012 @ 12:55 PDTAyush.JhaDatabaseReplyHow to force duplication of the rows from a small table on all AMPsAftab, Thanks for the response and the suggestion. What if I move all the data from the smaller table 'tableb' which has only 15 million rows into another table and create an altogether d...
2760804 Oct 2012 @ 12:53 PDTArashDatabaseReplyconvert string to date formatMany thanks for all the help Teradata! It solved my problem.  
2760704 Oct 2012 @ 12:26 PDTQaisar Aftab KianiDatabaseReplyHow to force duplication of the rows from a small table on all AMPsHi Ayush, The reason that your tablea is redistributed is because the join is on UPI and no index. TableA has a three columns NUPI, and in the join condition you are only using one column, so basi...
2760604 Oct 2012 @ 12:16 PDTQaisar Aftab KianiDatabaseReplyconvert string to date format SELECT '8/12/2012' AS COL1 , CAST(CASE WHEN CHAR_LENGTH(SUBSTRING(COL1 FROM 1 FOR POSITION('/' IN COL1)-1))=1 THEN '0'||SUBSTRING(COL1 FROM 1 FOR POSITION('/' IN...
2760504 Oct 2012 @ 11:49 PDTulrichDatabaseReplyconvert string to date formatsee my last comment on http://forums.teradata.com/forum/general/a-wish-list-for-future-versions-of-teradata
2760404 Oct 2012 @ 11:04 PDTJim ChapmanCloud ComputingReplyCertificate errors when trying to start VMserver. If by "VMserver" you mean the Oracle VM Server, then you are using the wrong product.  The Teradata VM is requires a VMWare product, such as VMWare Player. VMWare Player is ava...
2760304 Oct 2012 @ 10:36 PDTrobpallerGeneralReplyWish list for forum developmentIs the goal of the forums here to be more Q&A and less conversational? If so then I would suggest visiting StackOverflow and other StackExchange related sites. I believe there is a lot that cou...
2760204 Oct 2012 @ 10:00 PDTstani75ConnectivityTopic"Invalid date supplied for" errorMy database is a Teradata version 13.00.01.19 I retrieve data with a MS Excel v2003 file (using MS Query) Before to do that, I installed "the tdodbc__windows_i386.13.10.00.05" products ...
2760104 Oct 2012 @ 08:20 PDTArashDatabaseReplyconvert string to date formatBut this still would't work for some dates, e.g. '10/2/2012'
2760004 Oct 2012 @ 07:37 PDTmukeshsinghConnectivityReplyhow to install teradata express edition on windows 7Hi, I am looking for teradata express for my windows 7 32/64 bit machine. but what i am getting is only the TDE editions for VMware. Is there any edition available for Windows 7, so that i ca...
2759904 Oct 2012 @ 06:56 PDTAyush.JhaDatabaseReplyHow to force duplication of the rows from a small table on all AMPsAll, I understand that this discussion is old but my problem is new. I am using Teradat 13.10. I have a large table eg: tablea with NUPI as (col1,col2,col3) . This table has approx 400 million ro...
2759804 Oct 2012 @ 06:27 PDTtd_admirerDatabaseReplycoverting a SQL Server function into a TD SQL UDFHi experts, Any ideas or suggestions are greatly appreciated.   Thank you.
2759704 Oct 2012 @ 06:19 PDTulrichDatabaseReplyCompile Stored Procedures in BatchIf I understand your question correctly the answer would be no: see Carries comment in  http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies
2759604 Oct 2012 @ 05:13 PDTmjasrotiaDatabaseReplyCREATE TABLE Failed. 3933: The Maximum Possible Row Length in the Table is too Large.Also depends upon the max Data Block size set by the DBA since a table row has to completely fit inside a Data Block.
2759504 Oct 2012 @ 04:38 PDTQaisar Aftab KianiDatabaseReplyCompile Stored Procedures in Batchfor example?
2759403 Oct 2012 @ 09:58 PDTgeethareddyGeneralReplyIs automation worth for cleaning Orphan Rights and Leftover Spool?Thanks for the response. But my question is, in case of cleaning the orphan rights the only way is we can clean them during any maintenance activities. And with leftover spool, it is not promised t...
2759303 Oct 2012 @ 09:54 PDTpradeeshGeneralReplyIs automation worth for cleaning Orphan Rights and Leftover Spool?It will get be good practice to clear the left over spool space for a system which is not bringing down once in quarter. We have scheduled a weekly job sincere regards, Pradeesh  
2759203 Oct 2012 @ 09:17 PDTDBAMagicmanToolsReplyTeradata WalletHi   I tried using TDWallet with two different utilities .BTEQ (T14.0.0.4) and ARCMAIN (T14.0.0.3). It seemed to have worked fine with BTEQ but gave an error in ARCMAIN.Im using CLIV2 T14.0....
2759103 Oct 2012 @ 08:22 PDTEN186010ToolsTopicUnix Shell Scripts on Teradata utilities that are currently running in production - Wants to set up standard and guildlinesFolks, Just wondering if you can help me on this, a major client wanted to have some working copies of a currently running unix shell script that executes Bteq which also captures error codes and ...
2759003 Oct 2012 @ 08:16 PDTEN186010ToolsTopicTeradata XML ServicesFolks, Just wondering which one of you are using Teradata XML Services, a client is interested to know how many of our existing customers has used Teradata XML Services and how is it being used (e...

Pages