All forum activity

#DateUserForumTypeThreadPost
5906910 Aug 2016 @ 12:31 PDTInguvaDatabaseReplyConvert text to a timestamp sel to_timestamp('june 7,2016,12' ,'Month DD,YYYY,HH') Try This It worked for me
5906810 Aug 2016 @ 12:17 PDTljohnnyDatabaseTopicHow to call a function from a procedure call in TeradataI am creating a stored procedure. Let's call it SP1. In SP1, I need to call SP2, and one of the input parameter needs to be passed in by calling a function Func1 ******************************...
5906710 Aug 2016 @ 12:16 PDTInguvaDatabaseReplyconvert varchar data into timestamp sel cast('2016-08-03 08:32:03' as timestamp format'yyyy-mm-ddbhh:mi:ss') This Worked for me Try once
5906609 Aug 2016 @ 11:50 PDTstami27ToolsReplyTPT load failure - Please suggestThis is the complete installation on this machine $rpm -qa|sort| grep "15.10" arc1510-15.10.01.01-1.noarch bteq1510-15.10.01.03-1.i386 cliv21510-15.10.01.04-1.noarch fastexp1510...
5906509 Aug 2016 @ 10:53 PDTjosephmichael.navarroToolsTopicComplete TTU removalWhen I run TTUListProducts.exe, it shows that I still have the following apps even though I already uninstall it. Version                 Display Name ...
5906409 Aug 2016 @ 09:40 PDTjainayush007GeneralReplyLooking for help with regards to nested aggregatesAlternatively, if we have to do a sub query, is that a way we can achieve a result set as below -  Find Avg within (A,C) and populate only for the first occurance of an I<> in a C<&g...
5906309 Aug 2016 @ 09:17 PDTskbinwalConnectivityTopicODBC connectivity to teradata from RHELHi, As per a post dated 2013 Teradata odbc didnt support Fast Export or any other utilities. Is it still the case or has there been an update on this. I need to connect to teradata database from ...
5906209 Aug 2016 @ 08:58 PDTjainayush007GeneralReplyLooking for help with regards to nested aggregatesHello, I need help as well on a case for nested aggregation as well.In this sample data, I need to find avg of field D over C and then sum them up over A in one query. Can it be done without sub qu...
5906109 Aug 2016 @ 08:32 PDTjosephmichael.navarroConnectivityReplyConnectivity issues for SQL Assistant 15Same thing here adjrock
5906009 Aug 2016 @ 07:39 PDTkrishna1985DatabaseTopicconvert varchar data into timestampHi All, can you please help me with this   I am trying to convert below varchar records into timestamp.    2016-08-03 8:32:03 2016-08-03 11:56:34   Tried mul...
5905909 Aug 2016 @ 07:34 PDTkrishna1985DatabaseReplyConvert text to a timestampHi All I am trying to convert  2016-08-03 8:32:03 2016-08-03 11:56:34  which are in varchar to timestamp. can you please help me
5905809 Aug 2016 @ 03:41 PDTdipakranaDatabaseTopicLock a table row by rowhashHello,    Is it possible to explecitely lock a row or a set of rows of a table in a bteq/tpump through out the session?   What will happen if only one row is locked due to update a...
5905709 Aug 2016 @ 02:57 PDTtmwConnectivityReplyExcel 2016 VBA ConnectionI had an update where the connection was working great in Excel 2016, and everything was great.  Then, just last week there was an update that returned to the same problem, and I'm back to...
5905609 Aug 2016 @ 02:18 PDTcrazyrama5DatabaseReply Merge the continuous rows with date range( sequential rows should merge)Thanks Johannes for responding so quicly.  we got it. SELECT  CUSTOMER_ACCOUNT_ID            , OLD_RECORD_START_DT         &...
5905509 Aug 2016 @ 02:17 PDTbjaversConnectivityReplyOLEDB Driver of TD15.10Any solution on this one?  We have been attempting to use the .net connector however seems like it will work on the initial table create but fails to write subsequent runs.  
5905409 Aug 2016 @ 01:00 PDTblue_eyed_byteDatabaseTopicOptions to compare contents of two tablesHello, From your experience, what is the best option for comparing contents of two tables? Both ways! - full outer join? - minus applied both ways? - except? - not exist applied both ways? Le...
5905309 Aug 2016 @ 11:05 PDTJohannes VinkDatabaseReply Merge the continuous rows with date range( sequential rows should merge)this topic did help me in the past: https://forums.teradata.com/forum/general/need-help-merging-consecutive-and-overlapping-date-spans i ended up using dnoets olap function (how typical). however...
5905209 Aug 2016 @ 11:02 PDTtdcvgraoTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Thank you, it is working fine for me now. Appreciate your help.
5905109 Aug 2016 @ 10:53 PDTJohannes VinkData ModelingReplyAJI creation for a single high priority querySAP data... Microstrategy... naming convention like that of TAS solution from Teradata... cool! is a sparse ji also a solution? on spend = Y with a partitioning on fiscal period name. by the way:...
5905009 Aug 2016 @ 10:19 PDTtomnolanDatabaseReplyretrieve row count from Teradata MacroYou must use the EXECUTE MacroName command to execute a macro, and No, it is not possible to use an execute command as a sub-select or derived table.   Hypothetical SQL syntax that is NOT su...
5904909 Aug 2016 @ 09:42 PDTtomnolanToolsReplyReg: SQL Assistant download for Mac OSSQL Assistant is a Windows-only product, and is not available on Mac OS.   As an alternative, we recommend Teradata Studio or Teradata Studio Express for use on Mac OS. They are availab...
5904809 Aug 2016 @ 09:34 PDTDPKKUMARARORADatabaseReplyRetrieve Rows where a change in values (intwo columns) occured Hi,   Please have a look at below solution. Hope this is working as per your requirement.   SELECT  CLIENTID,PLATFID,           CPP, &...
5904709 Aug 2016 @ 09:24 PDTtomnolanConnectivityReplyError while getting database functions via JDBCWork on that is in progress. We plan to provide support for the DatabaseMetaData.getFunctions method in an upcoming release of the Teradata JDBC Driver.
5904609 Aug 2016 @ 09:16 PDTtomnolanConnectivityReplyTeradata JDBC Connection FailureTeradata Studio Express does not include the Teradata Database.   There are several free versions of the Teradata Database available for download. You must download them separately from Tera...
5904509 Aug 2016 @ 09:12 PDTmb255021Data ModelingReplyAJI creation for a single high priority queryThanks for your suggestion Mr VandeBerg. AJIs have a lot of restrictons and I was hoping for a quick fix :) Which I've discovered isn't possible. This view only has one query running aga...

Pages