#DateForumTypeThreadPost
6811 Feb 2014 @ 05:29 PSTDatabaseReplydynamic index collect stats statementThanks Guys! I tried udfconcat but I believe it pulls back all the index columns (primary and secondary) on the same line.  Do you know of any way to only pull the UPI or USI columns?  I...
6710 Feb 2014 @ 05:03 PSTDatabaseReplydynamic index collect stats statementI was able to utilize a 3th party SP called Run_Index_CS_SP to collect stats on primary and secondary indexes.  Still curious to see if anyone has been able to generate dynamic sql similar to ...
6610 Feb 2014 @ 04:21 PSTDatabaseTopicdynamic index collect stats statementHi all, I would like to execute some dynamic sql that goes out to a table and pulls back the columns of a primary index and plugs them into a collect statistic statement.  Something like: se...
6517 Dec 2013 @ 04:21 PSTDatabaseReplyCollect stats doubtThanks Saeed!... that is what I thought.  For those customers on versions prior to 14.00, it is good to know that order matters when it comes to multi-column statistics collection.  Nothi...
6413 Dec 2013 @ 08:43 PSTDatabaseReplyCollect stats doubtI'm not sure if this applies to 14, but prior versions are a bit tricky when collecting multicolumn stats.  The optimizer only looks at the first 16 bytes of data.  For example, if I ...
6328 Oct 2013 @ 11:11 PDTDatabaseTopicCompiling Stored Procedures with No SPL (No Stored Procedure Language)I have a few user stored procedures in our TEST environment that I would like to re-compile.  These procs do not have any stored procedure language associated with them.  When I try to sh...
6213 Sep 2013 @ 11:25 PDTDatabaseReplyHow to get data from Excel to Teradata table without using teradata olap connectorTry the following: 1. Save your spreadsheet as tab delimited 2. Open up SQLA 3. Navigate to File and select 'Import Data' 4. Compose something similare to:      ins...
6130 Aug 2013 @ 09:41 PDTToolsReplyTPT Installation Verification ScriptI believe I have found it so thought I would also share... The script is called tptvalidate.bat and is located in the following directory: C:\Program Files (x86)\Teradata\Client\14.00\Teradata Pa...
6030 Aug 2013 @ 09:14 PDTToolsTopicTPT Installation Verification ScriptAt one time I found a script that I had been able to run in order to verify a TPT installation.  I am upgrading the TTU from 13.10 to 14.0 on an ETL Windows server.  I would like to use t...
5912 Jun 2013 @ 10:45 PDTData ModelingReplyEffect of reversing the order of columns in mutli-column statsI believe the order is determined by the order in which the columns are defined in the table definition (up to 13.10).  It is a good practive to define smaller sized columns first just in case...
5830 Apr 2013 @ 10:07 PDTDatabaseTopicExpired Password PromptEvery now and then I run into a situation where a user's password expires and I am not able to reset the password to produce a prompt to change.  I run all users through a profile.  I...
5726 Apr 2013 @ 08:31 PDTDatabaseTopicInformatica ODBC ErrorHave any Informatica users out there ever encountered the following failure:   Severity: ERROR Timestamp: 4/26/2013 10:51:03 AM Node: node01_DVWPAP0031 Thread: READER_1_1_1 Process ID: 1...
5612 Apr 2013 @ 02:56 PDTDatabaseReplydisable enable logonsI was playing around a bit and came up with the following... Not sure if this is what you are looking for: sel 'revoke logon on all from ' || '"' || trim(databasename) || '...
5510 Apr 2013 @ 03:31 PDTDatabaseTopicTeradata DBLinkA question that I get from developers on a routine basis is "When is Teradata going to develop DB Links?"  As a DBA, I could use this functionality as well.  Has anyone else eve...
5404 Apr 2013 @ 10:36 PDTDatabaseReplyNo More Spool Space.... on which AMP?Just out of curiosity.... why do you need to know which AMP?  Is it to determine null values?
5323 Mar 2013 @ 02:09 PDTDatabaseReplyMVC is helpful for running queiresNo one can say for sure because of all the unknowns associated with your situation and queries, but more rows per block many time results in better query performance.  Usually MVC can achieve ...
5223 Mar 2013 @ 01:58 PDTDatabaseReplyData movement across Terdata serverIf the requirements permit it, I usually move data from a backup between systems.  There are usually faster connections to your backup media and the source system is not effected by a Fast Exp...
5114 Mar 2013 @ 03:05 PDTDatabaseReplyDBLink in TeradataPossible good news... I get this request often... Teradata may try to develop this in a future release... does not currently exist.
5013 Mar 2013 @ 03:06 PDTToolsReplySQLA - Deleting Add Favorites EntriesDang Dieter.... How did you know that?  :)  I looked for documentation everywhere and couldn't find it!  Thank you very much!   Joe
4908 Mar 2013 @ 07:26 PSTToolsTopicSQLA - Deleting Add Favorites EntriesI am on SQA 14.0 and am trying to figure out a way to delete an entry I have created in 'Add Favorites'.  I love this feature but am not able to clean up old entries.  Does anyone...
4806 Feb 2013 @ 07:38 PSTDatabaseReplyETL Process results in contention on Teradata tableHave you created a view on top of each table defined as LOCK ROW FOR ACCESS?  Writing directly against the table, instead of through the view, may be your issue.
4705 Feb 2013 @ 10:31 PSTDatabaseTopicSurvey: ERP Source = UTF8, Teradata Column definitions = (Latin or Unicode)?I would like to conduct a bit of a survey from all those Teradata customers out there that pull from Unicode sources (i.e. SAP). When setting up the EDW, which of the following scenarios would you...
4605 Feb 2013 @ 10:22 PSTDatabaseReplyStored Procedure Input Parameter ProblemThanks Dieter,   That is exactly what it was.... operator error! :)   Joe
4530 Jan 2013 @ 05:42 PSTDatabaseTopicStored Procedure Input Parameter ProblemI have created a basic stored procedure whose parameters are defined as:   REPLACE PROCEDURE STORED_PROCS.SP_UPDATE_SAP_CTRL_TABLE (IN "in_DELTA_BUFFER_HR" integer, IN "in_D...
4414 Dec 2012 @ 10:50 PSTDatabaseTopicTable references in a COMPLEX viewWe have defined a view layer on top of all tables in our edw.  For example, every tabledatabase.table_t has a corresponding view defined as viewdatabase.table.  We have a semantic view la...

Pages