223 | 07 May 2009 @ 05:29 PDT | Database | Reply | distinct rows | Hello,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... |
222 | 05 May 2009 @ 11:57 PDT | Database | Reply | FETCH NEXT statement | Hello,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 |
221 | 05 May 2009 @ 08:14 PDT | Tools | Reply | Fastload utility | Hello,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... |
220 | 04 May 2009 @ 04:07 PDT | Database | Reply | Rows updated inserted | Hello,It is perhaps due to fact that you need to use "ACTIVITY_COUNT" not "ACTIVITYCOUNT"! :)HTH!Regards,Adeel |
219 | 17 Apr 2009 @ 01:21 PDT | Analytics | Reply | Coverting Char to Date | Hello,You can do that using CAST and FORMAT clause .... e.g. SELECT CAST('20090417' AS DATE FORMAT 'YYYYMMDD');HTH!Regards,Adeel |
218 | 15 Apr 2009 @ 04:50 PDT | Database | Reply | corresponding teradata query for a oracle query | Hello,In Teradata, you can list the table definition using SHOW TABLE command. For example...."SHOW TABLE Table1;".HTH!Regards,Adeel |
217 | 15 Apr 2009 @ 01:48 PDT | Database | Reply | Truncating character column | Hello,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... |
216 | 14 Apr 2009 @ 02:04 PDT | Database | Reply | Need os PERM Space in Stored Procedure | Hello,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 |
215 | 14 Apr 2009 @ 02:03 PDT | Database | Reply | CONVERT and DATEDIFF in Teradata | http://www.teradata.com/teradataforum/FindPost15071.aspx |
214 | 14 Apr 2009 @ 02:02 PDT | UDA | Reply | CONVERT and DATEDIFF in Teradata | Hello,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 ... |
213 | 09 Apr 2009 @ 02:53 PDT | UDA | Reply | FORMAT m/d/yy column as DD/MM/YYYY | Hello,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... |
212 | 09 Apr 2009 @ 02:49 PDT | Database | Reply | Identify unique indexes/keys using DBC views | Hello,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... |
211 | 12 Mar 2009 @ 03:58 PDT | UDA | Reply | convert varchar to timestamp | Hello,I believe life is not that difficult! :)SELECT CAST ('20090310181010' AS TIMESTAMP(0) FORMAT 'YYYYMMDDHHMISS');Regards,Adeel |
210 | 02 Mar 2009 @ 11:11 PST | Database | Reply | sql question | Hello,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 |
209 | 25 Feb 2009 @ 06:35 PST | UDA | Reply | extract date value in format YYYYMMDDHHMMSS | Hello,Try by casting it to TIMESTAMP(0).Regards,Adeel |
208 | 03 Feb 2009 @ 11:41 PST | Database | Reply | Regarding LEAD (analytical function) function in TERADATA | Great! :) |
207 | 03 Feb 2009 @ 05:13 PST | Database | Reply | Regarding LEAD (analytical function) function in TERADATA | Hello,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... |
206 | 22 Jan 2009 @ 12:26 PST | Database | Reply | CAST TIME Problem | Hello,Have you tried running the same query from BTEQ or SQL Assistant? Or try to cast it as VARCHAR. Does that work?Regards,Adeel |
205 | 21 Jan 2009 @ 11:38 PST | Training | Reply | Help Regarding NR0-016 | Hello,Following contains the details:http://www.teradata.com/t/page/112724/index.htmlRegards,Adeel |
204 | 21 Jan 2009 @ 11:31 PST | Analytics | Reply | UDFCALLNAME, date problem | Hello,Try as following:SELECT "date" FROM Table1;SELECT a."date" FROM Table1 a;HTH.Regards,Adeel |
203 | 20 Jan 2009 @ 07:21 PST | Training | Reply | New to TeraData | Hello 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... |
202 | 20 Jan 2009 @ 07:17 PST | Training | Reply | Teradata Basic Certification Help | Hello,Following link has the information you are looking for:http://www.teradata.com/t/page/112278/index.htmlHTH.Regards,Adeel |
201 | 06 Jan 2009 @ 04:33 PST | Database | Reply | Select only when changing is occured | Following 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... |
200 | 04 Jan 2009 @ 11:04 PST | Database | Reply | cursors with parameters | Hello,Parameterized cursors can be handled in Teradata using dynamic-SQL.HTH.Regards,Adeel |
199 | 04 Jan 2009 @ 11:03 PST | Database | Reply | problem in converting oracle stored procedure | Hello,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... |