#DateForumTypeThreadPost
22307 May 2009 @ 05:29 PDTDatabaseReplydistinct rowsHello,GROUP BY clause does not return the 'first row', instead it groups the values of the columns it is defined on!It is a good idea to provide the SQL as well, so you get the solution quickly and...
22205 May 2009 @ 11:57 PDTDatabaseReplyFETCH NEXT statementHello,It is not required for a WHERE clause to be always static, it can be dynamic as well!And as suggested by Dieter, actual code is the requirement to solve this issue!Regards,Adeel
22105 May 2009 @ 08:14 PDTToolsReplyFastload utilityHello,You need to use the concept of 'filler' .... which means define all the columns in the define block with proper data-types .... but only use those required in the INSERT clause and simply ign...
22004 May 2009 @ 04:07 PDTDatabaseReplyRows updated insertedHello,It is perhaps due to fact that you need to use "ACTIVITY_COUNT" not "ACTIVITYCOUNT"! :)HTH!Regards,Adeel
21917 Apr 2009 @ 01:21 PDTAnalyticsReplyCoverting Char to DateHello,You can do that using CAST and FORMAT clause .... e.g. SELECT CAST('20090417' AS DATE FORMAT 'YYYYMMDD');HTH!Regards,Adeel
21815 Apr 2009 @ 04:50 PDTDatabaseReplycorresponding teradata query for a oracle queryHello,In Teradata, you can list the table definition using SHOW TABLE command. For example...."SHOW TABLE Table1;".HTH!Regards,Adeel
21715 Apr 2009 @ 01:48 PDTDatabaseReplyTruncating character columnHello,As I believe, there are several ways to solve a given problem.... but not all may be the best possible.If you are not comfortable using built-in functions/best possible solution....you can al...
21614 Apr 2009 @ 02:04 PDTDatabaseReplyNeed os PERM Space in Stored ProcedureHello,SPs are not stored as definitions in dictionary because they are pre-compiled .... which means they are not supposed to be compiled on each call.HTH!Regards,Adeel
21514 Apr 2009 @ 02:03 PDTDatabaseReplyCONVERT and DATEDIFF in Teradatahttp://www.teradata.com/teradataforum/FindPost15071.aspx
21414 Apr 2009 @ 02:02 PDTUDAReplyCONVERT and DATEDIFF in TeradataHello,It is a good idea, not to flood the forum with same question! :)DATEDIFF can be converted to SQL or UDF from OracleUDFs or custom UDF (perhaps the best option :)).CONVERT can be converted to ...
21309 Apr 2009 @ 02:53 PDTUDAReplyFORMAT m/d/yy column as DD/MM/YYYYHello,As per my knowledge, Teradata doesn't support single digit date values i.e. D, M, 1/2/2009, etc.Your best option will be to do some pre-processing on such fields and make them 2 digit date va...
21209 Apr 2009 @ 02:49 PDTDatabaseReplyIdentify unique indexes/keys using DBC viewsHello,Yes, you are looking in a right view, just verify if it does have rows in it.Rest, as suggested by Gautam, use TRIM on DatabaseName, TableName, IndexName and ColumnName and also if you are do...
21112 Mar 2009 @ 03:58 PDTUDAReplyconvert varchar to timestampHello,I believe life is not that difficult! :)SELECT CAST ('20090310181010' AS TIMESTAMP(0) FORMAT 'YYYYMMDDHHMISS');Regards,Adeel
21002 Mar 2009 @ 11:11 PSTDatabaseReplysql questionHello,As far as my limited knowledge is concerned, I genuinely believe rows can be 1, 2.... but not 1.1, 2.75, 3.0008. Am I missing something?Regards,Adeel
20925 Feb 2009 @ 06:35 PSTUDAReplyextract date value in format YYYYMMDDHHMMSSHello,Try by casting it to TIMESTAMP(0).Regards,Adeel
20803 Feb 2009 @ 11:41 PSTDatabaseReplyRegarding LEAD (analytical function) function in TERADATAGreat! :)
20703 Feb 2009 @ 05:13 PSTDatabaseReplyRegarding LEAD (analytical function) function in TERADATAHello,No, so far there is no equivalent function in Teradata, though you can do that as follows:DROP TABLE Table1;CREATE VOLATILE TABLE Table1 (Last_Name VARCHAR(255), Hire_Date DATE) ON COMMIT PRE...
20622 Jan 2009 @ 12:26 PSTDatabaseReplyCAST TIME ProblemHello,Have you tried running the same query from BTEQ or SQL Assistant? Or try to cast it as VARCHAR. Does that work?Regards,Adeel
20521 Jan 2009 @ 11:38 PSTTrainingReplyHelp Regarding NR0-016Hello,Following contains the details:http://www.teradata.com/t/page/112724/index.htmlRegards,Adeel
20421 Jan 2009 @ 11:31 PSTAnalyticsReplyUDFCALLNAME, date problemHello,Try as following:SELECT "date" FROM Table1;SELECT a."date" FROM Table1 a;HTH.Regards,Adeel
20320 Jan 2009 @ 07:21 PSTTrainingReplyNew to TeraDataHello Ajay.K,Please refer following link for details:http://www.teradata.com/teradataforum/FindPost14138.aspxAbout how long will it take, it totally depends on you, if you are good in Databases and...
20220 Jan 2009 @ 07:17 PSTTrainingReplyTeradata Basic Certification HelpHello,Following link has the information you are looking for:http://www.teradata.com/t/page/112278/index.htmlHTH.Regards,Adeel
20106 Jan 2009 @ 04:33 PSTDatabaseReplySelect only when changing is occuredFollowing may explain it a bit more:DROP TABLE Table1;CREATE VOLATILE TABLE Table1(Col1 VARCHAR(10), Col2 VARCHAR(10), Col3 DATE) ON COMMIT PRESERVE ROWS;INSERT Table1 VALUES('A', '001', '2008-10-1...
20004 Jan 2009 @ 11:04 PSTDatabaseReplycursors with parametersHello,Parameterized cursors can be handled in Teradata using dynamic-SQL.HTH.Regards,Adeel
19904 Jan 2009 @ 11:03 PSTDatabaseReplyproblem in converting oracle stored procedureHello,Functions can be replaced with stored-procedure having an OUT variable. But you need to consider the no. of times it will be called, or if possible convert and embed its logic as SQL.For para...

Pages