#DateForumTypeThreadPost
827 May 2014 @ 03:41 PDTDatabaseTopicStored ProcedureGood day everyone, I am trying to figure out if ai have a potential concurrency issue, or some other problem with a stored procedure that i recently ported from SQL Server Database: 13.10.07 Appl...
708 Apr 2014 @ 03:37 PDTDatabaseReplyImplementing SCD type 2 using ANSI Merge in teradataDieter that's not technically true using Informatica and BTEQ.  I will explain.  For example from source to stage I load the data.  From Stage to image one, I perform a minus que...
624 Mar 2014 @ 02:53 PDTDatabaseReplyDelete or Drop a table if it already existsIf you're trying to do this in a procedure it would look something like this...  I would try and drop the volatile table on the fly and use error handling to trap the error... Then you can...
511 Feb 2014 @ 05:17 PSTDatabaseReplyOptimizer's inability to resolve variables for partitioningSanji,   This might be a little late, but have you tried to create a sparse join index based on the like clause scenario?  I believe 13 and 14 both support this.
428 Jan 2014 @ 03:40 PSTDatabaseReplyConcatanation of the rows from one columnsHere is a good query that I use to recursively find and create a sting of values for compression.  In it you will see how I concatenate the values together.   DROP TABLE VT_TEMP;   ...
324 Oct 2013 @ 10:05 PDTDatabaseReplyHow know if an index is used?Look at the DBQLobjTBL or DBQLOBJTBL_HST.  There is a TypeOfUse column.  With values like this 1 =   Found in the resolver 2 =   Accessed during query pr...
223 Oct 2013 @ 01:21 PDTConnectivityReply.Net Provider - Column Character SetIt is dbc. columns, not dbc.tables If you look in the dbc.columns table you will find what you looking for.  If you find a chartype = 1 then it character set latin and if you find chartype = ...
130 May 2013 @ 03:19 PDTDatabaseReplyStatistics information retrieved in dbc for Teradata 12Gents, Good day, we recently upgraded to a 8 or 9 node 6690 appliance and TD14, when I run the 64 bit query, I get an error on the NumValues and NumRows (expotional calculations).  With a num...