All forum activity

#DateUserForumTypeThreadPost
121728 Jun 2006 @ 11:23 PDTdhanredDatabaseReplyHow to calculate exponential values.Hi,I have found that we do not have a function in teradata to do exponential calculations.It can be acheived as followsTotal Amount = ColumnA* { [1 + (columnB/100) ] ^30 } can be calculated asTotal...
121628 Jun 2006 @ 09:28 PDTColumbusKidAnalyticsTopicMLOAD ErrorsIs there a way to remove rows that have insufficient data in a record within an MLOAD so the MLOAD will continue to load the rows that are of the proper length?**** 09:25:16 UTY4017 Not enough data...
121527 Jun 2006 @ 05:03 PDTdhanredDatabaseTopicHow to calculate exponential values.Hi all,I have a calculation that has to do the followingTotal Amount = ColumnA* { [1 + (columnB/100) ] ^30 }^ = to the power of Is there a function in teradata that we can use to calculate expone...
121427 Jun 2006 @ 03:18 PDTMadhanDatabaseTopicLastAccessDateHi,I want to populate the LastAccessDate of the table, as when the table is accessed by any user. Currently I am having NULL in that fields, how to populate the same automatically.Could any one hel...
121327 Jun 2006 @ 12:27 PDTj355gaToolsReplyStored ProceduresAnother disadvantage is the inability of Teradata stored procedures to return a data-set. The typical approach to circumvent this limitation is to insert to a temporary table and then - while main...
121227 Jun 2006 @ 11:12 PDTMattW At ATTDatabaseTopicIs there an Equivilant Function to Execute in Teradata.This is How I would write this in MS SQL SERVER 2003, how would I do this in Teradata. I mean use the Execute function. -- drop table temp;Create volatile Table TEMP As (Select'1060101' (int) star...
121127 Jun 2006 @ 10:49 PDTbswarmerToolsTopicSize Limit on Varchar / ConcatenatingI am needing to know if there is a size limit on either varchar fields or concatenated fields in Teradata. Thanks for your help!Brad
121027 Jun 2006 @ 09:48 PDTMattW At ATTDatabaseTopicHow do you declare a variable in Teradata SQL?First of all, I am new, and I am not sure where to post basic Teradata SQL questions.Anyway, outside of a SP, I am writing a long piece of code which I would like to use some variables in, but I ca...
120927 Jun 2006 @ 06:47 PDTPervez AhmedDatabaseTopicVerification of source dataIs there a way to validate source data within fastload or mload utilities.
120827 Jun 2006 @ 06:44 PDTPervez AhmedDatabaseTopicCollecting sample data for populating teradata tablesAre there any tools available to gather or create sample data that can be used in teradata utilities.
120727 Jun 2006 @ 04:49 PDTRob88UDATopicSomeone end this argument pleaseMy colleague says that in a TerraData all the data should be kept in TNF and any reports/models should be modelled directly over this.I say that there needs to be a logical layer that creates a bus...
120627 Jun 2006 @ 02:27 PDTvenkatesh_mutyalaUDAReplyconfidence showned in explain planHigh confidence: restricting condstatistics.– Restricting conditions exist on index(es) having no statistics, but estimates can be based upon a sampling of the index(es).Low confidence:– Res...
120527 Jun 2006 @ 01:02 PDTFredToolsReplyStored ProceduresIt's really not Stored Procedures that are the issue, it's the "cursor processing" you want to minimize. Whether you use embedded SQL in an application program or a Stored Procedure, cursor logic i...
120427 Jun 2006 @ 12:18 PDTtalal_ahmadToolsTopicStored ProceduresI have heard some people talking about the fact that usage of stored procedures is not recommended in Teradata.Being new to Teradata i really dont know much about all this and i would like some gui...
120326 Jun 2006 @ 11:33 PDTManoj_Kumar_ParmarDatabaseTopicJoinsAs we know the that "Explain" plan tells that which join plan the optimizer is choosing, but when writing the query can we sure that optimizer may choose which join plan(say ex: Merge, Nested, etc)
120226 Jun 2006 @ 04:24 PDTc9jadToolsTopicSQL MedianDoes anyone know how to calculate the median using SQL?
120126 Jun 2006 @ 02:11 PDTDHolderToolsTopicMLOAD .LAYOUT continueifI have data that is variable length and can be continued in any field with the character "\".I have the following defined. But I am getting an error message when I try to run. Is anyone more famila...
120026 Jun 2006 @ 12:20 PDTvirtuallyoursAnalyticsReplyCreate Volatile Table not working with Trimhiit's not the trim that wasn't working, it was the length.ansi syntax vs teradata syntax is the issue usually in these instances.see examples below, CHARS worked where LENGTH did not.THIS WORKED !...
119926 Jun 2006 @ 10:13 PDTBBR2ToolsReplySQL problemTry thisSEL CUST_N ,TR_MONTH ,SUM(MOVING_DIFF) OVER (PARTITION BY CUST_N ORDER BY TR_MONTH) AS GRP_SUMFROM (SEL CUST_N ,TR_MONTH ,TR_MONTH - SUM(TR_MONTH) OVER( PARTITION BY CUST_...
119826 Jun 2006 @ 09:59 PDTbhullToolsReplylooping through a macro?Create a stored procedure that executes the macro. You can put a loop in the stored procedure.Barry
119726 Jun 2006 @ 09:58 PDTbhullToolsReplylooping through a macro?Create a stored procedure that executes the macro. You can put a loop in the stored procedure.Barry
119626 Jun 2006 @ 09:34 PDTilyasUDATopicTutorialHi,I am beginner to datawarehousing. I have installed teradata at my laptop. Now How can I start using it. in Aug, I will start a job on teradata, and my employer knows I don't know anything about ...
119526 Jun 2006 @ 07:01 PDTVladDatabaseTopicget error msg: "Row size or Sort Key size overflow."there are no error when used odbc connection to db. this error showed when executing query throw oledb connection.why it is happened?
119426 Jun 2006 @ 04:19 PDTAmitToolsReplySQL problemThanks Dieter,I apologise for overlookin Distinct clause. Actually I was not aware of using Distinct in Having clause. I never used my common sense that I should try using Distinct while counting...
119326 Jun 2006 @ 04:05 PDTdnoethToolsReplySQL problemHi Amit,it's totally clear, that's why i wrote that solution using distinct.Why didn't you simply try it?Dieter

Pages