All forum activity

#DateUserForumTypeThreadPost
5789120 Jun 2016 @ 11:37 PDTdnoethDatabaseReplyRecursive Query Vs UNIONSeems like you want to return only the weeks with no negative value in the current and next week. This should be a simple task using OLAP-functions like this: select a,b,c from ( select ...
5789020 Jun 2016 @ 11:08 PDTdnoethGeneralReplyHow to download and install teradata on windows 10http://lmgtfy.com/?q=teradata+express+download
5788920 Jun 2016 @ 09:50 PDTPriti_KanalDatabaseReplyDynamically select TOP N rows from tableThanks for helping to resolve the issue...!! :)
5788820 Jun 2016 @ 08:44 PDTtoadrwToolsReplyEasy Loader Skip Column in Flat FileThank you for the response Steve!  Appreciate your help once again!
5788720 Jun 2016 @ 06:57 PDTrharitha7GeneralReplyInstall Teradata Windows or Open Susehi  i installed vmplayer. where i can get the virtual teradata express. help me through this.   Thnks.
5788620 Jun 2016 @ 06:54 PDTrharitha7Teradata Database on VMWareReplyConfused over which VM to downloadhi where i can find TDE for vm ? please help me through this.   Thanks.
5788520 Jun 2016 @ 06:52 PDTrharitha7GeneralReplyHow to download and install teradata on windows 10hi  can someone tell me where i can find teradata for vmware?   thnks
5788420 Jun 2016 @ 03:38 PDTmhusseyTeradata StudioTopicTeradata Studio does not show all of my authorized tables-I started working on a new project a few weeks ago, which requires me to use Teradata, Hadoop, and Aster. That being the case, I want to use Teradata Studio instead of Teradata SQL Assistant. Conne...
5788320 Jun 2016 @ 03:12 PDTericawang0829GeneralTopicAssign values based on dates by groupI have a table looks like this: groupID  Date 1   2016-01-03 1   2016-01-02 1   2016-01-01 2   2016-01-04 2   2016-01-05 2   2016-...
5788220 Jun 2016 @ 12:16 PDTfeinholzToolsReplyEasy Loader Skip Column in Flat FileThis is not currently available with "tdload".   In order to do this, you would need a script so that the "SELECT" portion of the APPL-SELECT canbe used to filter out the...
5788120 Jun 2016 @ 12:09 PDTtoadrwToolsTopicEasy Loader Skip Column in Flat FileHello: Is there a way to only load specific columns from a flat file using tdload?  Say my flat file has five columns, but I only need the last three.  Is there anyway to specify the fir...
5788020 Jun 2016 @ 11:39 PDTfeinholzToolsReplyNeed Help regarding TPT ODBC OperatorThe bundling of DataDirect drivers was first supported with TPT 14.10.00.06. If you upgrade to that efix level, you will get the drivers. However, you do need license files in order to use the dr...
5787920 Jun 2016 @ 09:51 PDTHarkrishDatabaseReplyLOBs are not allowed to be hashed issue in Recursive queryHi, I am facing the same problem. Can you put it over here if you were able to overcome the issue?
5787820 Jun 2016 @ 09:30 PDTjobbazarToolsReplyUsing Geospacial Import/Export java toolsI am also facing the same issue.  Can't laod IA 32-bit .dll on a AMD 64-bit platform. The error is related geojni.dll when it is linking..... Any idea how to fix this? Is there a 64 bi...
5787720 Jun 2016 @ 08:53 PDTklaementToolsReplyNeed Help regarding TPT ODBC OperatorThanx Carlos, I will try to convince them that they have no choice but to buy it if they want it. Regards
5787620 Jun 2016 @ 08:19 PDTdnoethDatabaseReplyDynamically select TOP N rows from table- use QUALIFY ROW_NUMBER instead of TOP - use dbc.ColumnsV instead of dbc.Columns - without ORDER BY the result is random If it's always all but the last four columns: SELECT COLUMNNAME ...
5787520 Jun 2016 @ 06:47 PDTPriti_KanalDatabaseTopicDynamically select TOP N rows from tableHi All, I need to perform dynamically select TOP N row from table. SELECT TOP (10-4) COLUMNNAME FROM DBC.COLUMNS WHERE DATABASENAME='DATABASE_NAME' AND TABLENAME ='TABLE_NAME';...
5787420 Jun 2016 @ 04:37 PDTarchana_2016ToolsReplyUsage of GetRow method in TPT API for exporting table data into csvThanks Steve for your valuable information!
5787320 Jun 2016 @ 04:07 PDTdnoethDatabaseReplyAfter Insert triggerWell, this is a website which simply copies the error descriptions from Teradata's Messages manual. http://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/index.html#page/General_Reference/B035_10...
5787220 Jun 2016 @ 03:02 PDTcrochlitDatabaseReplyAfter Insert triggerThe issue is well explained on this page: http://teradataerror.com/5424-A-triggered-action-statement-is-the-wrong-kind.html "SET" can only be used in a BEFORE row triggers
5787119 Jun 2016 @ 11:56 PDTNiteshMDatabaseReplyRecursive Query Vs UNION Table T1 Column A    Column B  Column C  Column D 123         001       1/1/2016   60 ...
5787019 Jun 2016 @ 09:20 PDTAVOTViewpointTopicData Labs Upgrade QuestionHi Teradata Gurus I am currently working on a project where I have installed Data Labs 15:00 (tddatalabsportlet v15.00.00.04-1). I installed Data Labs on the Viewpoint (version 15.00.00.01). I wi...
5786919 Jun 2016 @ 02:52 PDTCarlosALToolsReplyNeed Help regarding TPT ODBC OperatorHi. The bundled versions of DataDirect Oracle ODBC drivers have a 'trial period' and then a message of 'license expired' appears. I think the last TPT 14.10 versions have the driv...
5786818 Jun 2016 @ 05:05 PDTJhossymedinaDatabaseTopicsql create databaseI would like to know how I can do a sql to create my database with permission and install the vmware version does not work so I do graphic
5786718 Jun 2016 @ 01:19 PDTdpalepuGeneralReplyinterview helpDear Anand, Please email to dpbits710@hotmail.com Thanks in advance, Durga Prasad.

Pages