All forum activity

#DateUserForumTypeThreadPost
4988027 May 2015 @ 04:23 PDTCarlosALDatabaseReplyGet the date and time in yyyy-mm-dd 00:00:00 format in TERADATA SQLHi. In Teradata Dates are Dates, Times are Times and Timestamps are Timestamps. This is not Oracle. Cheers. Carlos.
4987927 May 2015 @ 04:11 PDTCarlosALDatabaseReplyNeed help in insert date statementHi. ON COMMIT PRESERVE ROWS is missing in your CREATE TABLE definition. Cheers. Carlos.
4987827 May 2015 @ 03:12 PDTGTREDDYDatabaseTopicGet the date and time in yyyy-mm-dd 00:00:00 format in TERADATA SQLHi All , I m new to teradata so i m not able to get the date in YYYY-MM-DD 00:00:00 format in TERADATA.   Can some one please help me ... Thanks in Advancce   GTREDDY
4987727 May 2015 @ 01:22 PDTnvk.kumaranTeradata ApplicationsTopicMLOAD returns error code 12 without logging into RDBMSHi,   I am getting the below message from the log. I could not see that there was a sucessfull connect happened to the DB at all. Usually "UTY6211 A successful connect was made to the R...
4987627 May 2015 @ 01:09 PDTk3naTeradata StudioTopicTeradata Studio and Teradata Analyst PackHello everybody, I would like to investigate possibilities of Teradata Visual Explain and I'm using Teradata Express Studio (v. 15.00) to connect our Teradata installation. To use the tool...
4987527 May 2015 @ 12:06 PDTGTREDDYConnectivityTopicUnable to connect to TERADATA from SSIS ADO.Net source Hi All , I m trying to connect to TERADATA server from SSIS using .Net Providers\.Net data provider for TERADATA. After giving the server name and credentials i m getting the below error.   &...
4987426 May 2015 @ 11:38 PDTrbradfo5DatabaseTopicUse of TITLES in RECURSIVE views and AJIsHi All, I am wondering whether it is possible to assign TITLES to columns created as part of a RECURSIVE VIEW, or when creating AJI's? The syntax statements don't seem to indicate it ispo...
4987326 May 2015 @ 11:35 PDThanluDatabaseTopicError in BETQHi all, I am  a newbie to use teradata. I learn from the book that I could create a test database using BETQ. However I got error message like that:  Teradata BTEQ 15.00.00.00 for WIN3...
4987226 May 2015 @ 11:23 PDTbhartiya007DatabaseReplyQuery PerformanceEvidently, there are many no confidence in the explain plan. Please check the stats.  
4987126 May 2015 @ 10:32 PDTTamilTigerDatabaseReplyROW_NUMBER() same valuesHi need help Table col1          col2 col3   col 4   calculatedcolumn 201301      1  ...
4987026 May 2015 @ 10:16 PDTRadsubra2003GeneralTopicUnused tablesHi,   I want to find all the tables which are no used for the past 3 months .How to find this information in teradata   Thanks
4986926 May 2015 @ 09:30 PDTGTREDDYConnectivityTopicunable to connect to Teradata server from ssis unable to connect to Teradata server from ssis Hi All , I m trying to connect to TERADATA server from ssis using .Net Providers\.Net data provider for TERADATA. Af...
4986826 May 2015 @ 09:27 PDTGTREDDYGeneralTopicunable to connect to Teradata server from ssisHi All , I m trying to connect to TERADATA server from ssis using .Net Providers\.Net data provider for TERADATA. After giving the server name and credentials i m getting the below error.  ...
4986726 May 2015 @ 06:10 PDTTdPassionDatabaseReplyNo More Spool Space IssuesCan any experts provide help on this issue??
4986626 May 2015 @ 04:58 PDTdjmdataAsterReplyCreate Test does not workI am seeing this same behavior with the latest code - did you ever find a solution?
4986526 May 2015 @ 03:38 PDTNikhil_TeradataDatabaseTopicNeed help in insert date statementHi, Here is my insert statement. CREATE VOLATILE TABLE A (ClickLoad_Dt DATE FORMAT 'yyyy/mm/dd'); INSERT INTO A(ClickLoad_Dt) SELECT MAX(CAST (click_dt AS DATE FORMAT 'yyyy/mm/...
4986426 May 2015 @ 02:33 PDTislandermanConnectivityTopicInstall DBD::ODBC using DataDirect Driver ManagerPlease help.  Vhari, you helped me on this in the past and I'm hoping you can help here as well.   I've actually got this working last year, however we have moved to a new serve...
4986326 May 2015 @ 10:11 PDTfgrimmerTeradata StudioReplyTeradata 15.1 Error when trying to execute queryLubert, Just to recap running queries: Select the connection profile in the Data Source Explorer (DSE) and double click to create a connection. Then choose the DSE toolbar button Open SQL Editor to...
4986226 May 2015 @ 09:19 PDTsa186016DatabaseReplyQuery band in procedure. SET QUERY_BAND ';' UPDATE FOR SESSION;"Hi Guys I have the same requirement but when i use following code,   BEGIN TRANSACTION; SET QUERY_BAND = 'Source=SQLAssistant;report...
4986126 May 2015 @ 08:02 PDTwmmiteffToolsTopicdata provider for Ole DBI know that functional updates are not being added to the data provider for OLEDB but I was curious if it was being updated for 15.10 and if it will be in the same path as the other executable...
4986026 May 2015 @ 05:56 PDTvincent91GeneralTopicInterpretation of PhysIOKB in dbc.QryLogStepsHello, I'm interested in the field PhysIOKB (dbc.QryLogSteps). It's based on the ExtraField30 in  DBC.DBQLStepTbl. As mentionned in the Database Administration documentation :...
4985926 May 2015 @ 05:41 PDTranakumar85@gmail.comDatabaseTopicColumn MaskingHi, is there any way to mask the column with different value on teradata, like: PersonID   PersonaName 1001         Thomas 1002         Jon 1001 &n...
4985826 May 2015 @ 05:21 PDTlsroxasTeradata StudioReplyTeradata 15.1 Error when trying to execute queryI just downloaded Studio Express 15.1 and I am experiencing the same error when trying to run a query on a Teradata Database. Test connection is ok. I am also able to see the database structure in ...
4985726 May 2015 @ 05:18 PDTs_reddyToolsTopicQuestion reg. TTU Support for RHEL on PowerPC platform Hi, From Product support matrix.TTU is currently not supported for the RHEL on PowerPc platform. Is there any Roadmap planned to support RHEL on PowerPc architecture? Thanks.
4985626 May 2015 @ 04:36 PDTstevekaHadoopTopicWill sqoop import command work with Teradata Dbase 15? Hello, I am new to Teradata.  For our project, we are currently using Teradata 13.10, and planning an upgrade to V. 15 soon. The client is doing "Big Data Analysis"  To pull th...

Pages