#DateForumTypeThreadPost
5103 Mar 2016 @ 08:25 PSTDatabaseReplysystem-determined change threshold for Stats-- TeradataChirag,   Cut from one of the Carrie's blog. Check this link for detailed Statistics Threshold Functionality on TD 14.10.   https://developer.teradata.com/blog/carrie/201...
5001 Mar 2016 @ 01:02 PSTDatabaseReplyoreplace of ->Memostone,   Ok. If thats the case, you can replace the unrecognizable character in the excel sheet. You will get lots of excel macros by googling or you can modify it manually.  ...
4901 Mar 2016 @ 10:03 PSTDatabaseReplyoreplace of ->Hi memostone   What is the characterset defined for the attribute? latin or unicode? I tried the below which I coundn't see anything in the SQLA 14.10 but when I saved in the excel, it ...
4819 Feb 2016 @ 09:11 PSTDatabaseReplyLink the Database Name/TableName to DatabaseID/TableIdEric,   Stats details can be fetched from DBC.StatsV view and it has almost all stats details of the objects. If you still wanna get the details from DBC.StatsTbl, try the below query(change...
4715 Feb 2016 @ 12:02 PSTDatabaseReplychar(23) to timestamp(6)Vinay,   The below query will give you the output for your requirements. Null as null, given char to timestamp. You need to manually convert this 20120629 08:01:39 to 2012-06-29 08:01:39. C...
4612 Feb 2016 @ 08:11 PSTDatabaseReplyTeradata SQL Assistant going to Not responding state while querying a tableC:\Users\<Username>\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt
4510 Feb 2016 @ 11:17 PSTDatabaseReplyExtract VS INTERVALGhalia,   Please check the below link. https://forums.teradata.com/forum/database/add-months-vs-interval HTH.   Thanks, Dinesh
4410 Feb 2016 @ 09:28 PSTDatabaseReplyTeradata SQL Assistant going to Not responding state while querying a tableMeenakshi, SQLA 13.11 seems very old now. One of the reasons might be memory error. Try upgrate SQLA to new version. Also, check SQLA error log, you might get some idea why it goes into not respo...
4308 Feb 2016 @ 08:24 PSTDatabaseReplyTeradata SQL Assistant going to Not responding state while querying a tableMeenakshi, Please provide the version of SQLA. Did you try querying few records like top 10 or sample 10?   Thanks, Dinesh
4203 Feb 2016 @ 02:33 PSTDatabaseReplyAccess Right AbbreviationsHi,   OA = OVERRIDE DUMP CONSTRAINT OR= OVERRIDE RESTORE CONSTRAINT   Below link has all the privilege codes. http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page...
4103 Feb 2016 @ 01:27 PSTDatabaseReplyDECODE Does Not Trap Divide by Zero ErrorSteve,   DECODE is very complex. You can convert DECODE into CASE statements. For capturing division by zero, you can use NULLIF or NULLIFZERO functions.   Thanks, Dinesh
4003 Feb 2016 @ 12:45 PSTDatabaseReplySelect Failed 2666 Invalid date suppliedHi Shaves,   Hope this helps.   cast(A.asof_DT as date) between cast(cast( '2016-01-01 00:00:00' as timestamp(0)) as date) and cast(cast( '2016-01-31 00:00:00' ...
3903 Feb 2016 @ 08:52 PSTDatabaseReplyHow to capture error in the error handling block for Manual Termination of Stored Procedure.Hi SSD,   This blog post might help you. https://developer.teradata.com/blog/mtmoura/2010/04/lets-talk-about-stored-procedures   Below manual has a lot of examples. http://www...
3803 Feb 2016 @ 07:52 PSTDatabaseReplysystem-determined change threshold for Stats CollectionHi Kishore/Chirag,   Cut from one of the Carrie's blog. Check this link for detailed Statistics Threshold Functionality on TD 14.10. https://developer.teradata.com/blog/carrie/2014...
3702 Feb 2016 @ 03:01 PSTDatabaseReplyABOUT TARAGUI ALERTHi,   There is no table holds such information as far I know. You have do some manual work(shell script) to get the error details by parsing the error logs.  Note : Provided that you ...
3602 Feb 2016 @ 11:29 PSTDatabaseReplyneed teradata logicPartha, Fred was right. INTERVAL YEAR will fail for February 29. Check the below link. https://forums.teradata.com/forum/database/how-to-write-current-date-1-year-in-teradata   Tha...
3502 Feb 2016 @ 09:37 PSTDatabaseReplyActivity Count from DBC.SYSEXECSQL in a Stored Procedure Shiro,   Deiter has already answerd your question. https://forums.teradata.com/forum/database/activity-count-of-dbc-sysexecsql   Anyway thanks.   Thanks, Dinesh
3411 Jan 2016 @ 09:43 PSTDatabaseReplyActivity Count from DBC.SYSEXECSQL in a Stored Procedure Hi, This thread will help you.   https://forums.teradata.com/forum/database/how-to-get-the-activity-count-in-a-stored-procedure   Thanks, Dinesh
3323 Dec 2015 @ 08:58 PSTDatabaseReplyPrivacy Enabled Data CompressionHi,   This link expains Enhancing security with views, external stored procedures and user-defined functions.   http://apps.teradata.com/tdmo/v08n01/Tech2tech/AppliedSolutions/Ho...
3202 Dec 2015 @ 03:12 PSTDatabaseReplyCustom Formatting Column Data - Teradata - UPC NumbersHi, This should work.   For PI_UPC_NBR_SYS_CD Sel CAST(CAST(1 AS FORMAT'-9(2)') AS CHAR(2))   For PI_UPC_MFG_ID, PI_POS_CASE_ID, & PI_POS_UNIT_ID Sel CAST(CAST(...
3130 Nov 2015 @ 12:50 PSTGeneralReplycalculate quarterend dates from datetime valueHi KJ, This should work. Most of the calendar related coulmns can be fetched from Sys_Calendar.BusinessCalendar table. This is tested in TD 14.10. Below is the query. Sel QuarterEnd as &q...
3024 Nov 2015 @ 05:47 PSTDatabaseReplyQuery to identify missing numbers between 2 valuesHi, This can be acheived through a SP. Created in TD 14.10.   Replace procedure db_name.createcols() DYNAMIC RESULT SETS 1 BEGIN DECLARE stnum INTEGER; DECLARE endnum INTEGER; DECLA...
2924 Nov 2015 @ 12:16 PSTDatabaseReplyCast variable length VARCHAR date/time strings to TIMESTAMPHi, This should work. Input Month is always in mm format like "02/23/2015 12:34". I'm just adding "0" to the month and casting it. Tested in 14.10.   Select '2/20...
2823 Nov 2015 @ 11:41 PSTDatabaseReplyTeradata performance impacted due to CPU overloadHi, You can get the queries run by top 4 user ids and check for 1. Product join, PJ consumes more CPU.  2. Statistics information of the tables that are involed in the queries by those user...
2723 Nov 2015 @ 09:15 PSTDatabaseReply'Date' BETWEEN 'select Date'Hi Lee, Here is the sql which gives you first and last day of the given date(2014-03-28) of the month.   select (ADD_MONTHS(cast('2014-03-28' as date) - EXTRACT(day FROM cast('2...

Pages