51 | 03 Mar 2016 @ 08:25 PST | Database | Reply | system-determined change threshold for Stats-- Teradata | 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/201... |
50 | 01 Mar 2016 @ 01:02 PST | Database | Reply | oreplace 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.
... |
49 | 01 Mar 2016 @ 10:03 PST | Database | Reply | oreplace 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 ... |
48 | 19 Feb 2016 @ 09:11 PST | Database | Reply | Link the Database Name/TableName to DatabaseID/TableId | Eric,
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... |
47 | 15 Feb 2016 @ 12:02 PST | Database | Reply | char(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... |
46 | 12 Feb 2016 @ 08:11 PST | Database | Reply | Teradata SQL Assistant going to Not responding state while querying a table | C:\Users\<Username>\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt
|
45 | 10 Feb 2016 @ 11:17 PST | Database | Reply | Extract VS INTERVAL | Ghalia,
Please check the below link.
https://forums.teradata.com/forum/database/add-months-vs-interval
HTH.
Thanks,
Dinesh
|
44 | 10 Feb 2016 @ 09:28 PST | Database | Reply | Teradata SQL Assistant going to Not responding state while querying a table | Meenakshi,
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... |
43 | 08 Feb 2016 @ 08:24 PST | Database | Reply | Teradata SQL Assistant going to Not responding state while querying a table | Meenakshi,
Please provide the version of SQLA. Did you try querying few records like top 10 or sample 10?
Thanks,
Dinesh
|
42 | 03 Feb 2016 @ 02:33 PST | Database | Reply | Access Right Abbreviations | Hi,
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... |
41 | 03 Feb 2016 @ 01:27 PST | Database | Reply | DECODE Does Not Trap Divide by Zero Error | Steve,
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
|
40 | 03 Feb 2016 @ 12:45 PST | Database | Reply | Select Failed 2666 Invalid date supplied | Hi 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' ... |
39 | 03 Feb 2016 @ 08:52 PST | Database | Reply | How 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... |
38 | 03 Feb 2016 @ 07:52 PST | Database | Reply | system-determined change threshold for Stats Collection | Hi 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... |
37 | 02 Feb 2016 @ 03:01 PST | Database | Reply | ABOUT TARAGUI ALERT | Hi,
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 ... |
36 | 02 Feb 2016 @ 11:29 PST | Database | Reply | need teradata logic | Partha,
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... |
35 | 02 Feb 2016 @ 09:37 PST | Database | Reply | Activity 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
|
34 | 11 Jan 2016 @ 09:43 PST | Database | Reply | Activity 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
|
33 | 23 Dec 2015 @ 08:58 PST | Database | Reply | Privacy Enabled Data Compression | Hi,
This link expains Enhancing security with views, external stored procedures and user-defined functions.
http://apps.teradata.com/tdmo/v08n01/Tech2tech/AppliedSolutions/Ho... |
32 | 02 Dec 2015 @ 03:12 PST | Database | Reply | Custom Formatting Column Data - Teradata - UPC Numbers | Hi, 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(... |
31 | 30 Nov 2015 @ 12:50 PST | General | Reply | calculate quarterend dates from datetime value | Hi 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... |
30 | 24 Nov 2015 @ 05:47 PST | Database | Reply | Query to identify missing numbers between 2 values | Hi, 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... |
29 | 24 Nov 2015 @ 12:16 PST | Database | Reply | Cast variable length VARCHAR date/time strings to TIMESTAMP | Hi, 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... |
28 | 23 Nov 2015 @ 11:41 PST | Database | Reply | Teradata performance impacted due to CPU overload | Hi,
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... |
27 | 23 Nov 2015 @ 09:15 PST | Database | Reply | '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... |