#DateForumTypeThreadPost
13415 Nov 2011 @ 09:55 PSTDatabaseReplyunable to create a table with 600 columns What error message is being returned? Teradata 13.10 supports 2048 columns so it isn't necessarily the number of columns that is reason for the failure.
13315 Nov 2011 @ 09:29 PSTUDAReplydistinct vs group by, insert vs create as @barcoo - Have you compared the EXPLAIN plans of the UNION in a CREATE TABLE AS vs CREATE TABLE and INSERT INTO? Have you tested it yet?
13215 Nov 2011 @ 09:24 PSTGeneralReplyHow to find list of users by table name Access Logging will only capture that information if you have enabled access logging. As for DBQL if you are retaining the object level data you can use the QryLog and QryLogObjects views (o...
13115 Nov 2011 @ 09:06 PSTGeneralReplyHelp with COLLECT STATS http://www.info.teradata.com/edownload.cfm?itemid=102320054 - Teradata 13.10 SQL Request and Transaction Processing manual
13026 Oct 2011 @ 07:09 PDTGeneralReplyTeradata compatibility with Windows 7 client operating system I have SQL Assistant 13.x running in a Windows 7 VMware guest OS with no trouble. Are you having a specific problem?
12914 Oct 2011 @ 06:58 PDTDatabaseReplyBteq equivalent of Sqlplus 'whenever sql error exit failure' Good call Carlos! +1 for SET MAXERROR.
12813 Oct 2011 @ 08:40 PDTDatabaseReplyDynamic SQL to recreate existing USI Here is a some recursive SQL that will get you down the path to accomplishing what you need to do. It will need some tweaking to drop out any columns that whose data type is TIMESTAMP.  ...
12713 Oct 2011 @ 07:42 PDTDatabaseReplyTable Growth using dictionary tables I believe PDCR is a Managed Services offering from Teradata. Your DBA or Teradata CSR should be able to assist you with identifying whether or not PDCR has been installed.  Otherwise, y...
12613 Oct 2011 @ 07:30 PDTDatabaseReplyBteq equivalent of Sqlplus 'whenever sql error exit failure' I don't believe so. You could create a single error handling section and then use the .IF ERRORCODE > 0 construct to jump to that section:   .LABEL ErrorHandler /* || Perf...
12513 Oct 2011 @ 07:11 PDTGeneralReplyTeradata SQL Extensions I have been asked to do this same thing in the past. In the Teradata 12 Manuals, SQL Fundamentals Manual, Appendix E contains a table that provides information about the differences between ANSI...
12413 Oct 2011 @ 06:31 PDTGeneralReplyInstalling Viewpoint 13.11 and 13.12 Have you considered asking in the Viewpoint Forum? Generally speaking, your Teradata CSR should be able to acquire the software and perform the upgrades for you. However, if you are aski...
12313 Oct 2011 @ 06:28 PDTGeneralReplyControl characters while exporting the data You can find a workaround here: http://forums.teradata.com/forum/tools/fastexport-how-to-export-without-beginning-two-bytes
12213 Oct 2011 @ 06:24 PDTGeneralReplyCalender Widget You may have better success asking this question in the Viewpoint Forum. 
12113 Oct 2011 @ 06:21 PDTGeneralReplyProblem with Timestamp in SQL assistant It may be helpful to know which version of ODCB and SQL Assistant you are using as well.  Have you tried CAST(MyTimestamp6 AS CHAR(26)) in SQL Assistant to see if when returned to SQL A...
12013 Oct 2011 @ 05:55 PDTDatabaseReplyTeradata Driver Questions Maybe I am miss understanding the question. But you can have Teradata .Net and the Teradata ODBC driver installed concurrently. The use of each is determined by the connection method employed by...
11913 Oct 2011 @ 05:04 PDTDatabaseReplyHow do you convert a regexp_instr of oracle in teradata The following SQL test can be done without having to create tables as you alluded in your StackOverflow question creating tables was not possible. This test yielded 1 for both statements. SEL...
11816 Aug 2011 @ 11:12 PDTViewpointTopicHow to include query band details in Viewpoint Alert email for TASM Aborts?Is there a way in the current release of Viewpoint (13.11.x) to include the query band name value pairs, if they exist, in the emails generated by the Viewpoint Alert mechanism? While they are ...
11714 Apr 2011 @ 09:17 PDTDatabaseReplymutiple layer of views on core databaseAny joins or set operations such as UNION, MINUS, EXCEPT in Layer C are going to impact performance. To what extent depends on the underlying tables that are being accessed, their data distribution...
11609 Apr 2011 @ 04:33 PDTDatabaseReplyCollect stats on single and multiple columns together - Performance advantageSee my response (which references some articles found on here): http://teradataquestions.com/questions/343/collect-stats-on-single-and-multiple-columns-together/344#344
11505 Apr 2011 @ 06:57 PDTDatabaseReplyhow to create a user, database and table in sql assistant?Check these manuals out: http://www.info.teradata.com/edownload.cfm?itemid=102320036 http://www.info.teradata.com/edownload.cfm?itemid=102320038 They will provide you with the details surround...
11429 Mar 2011 @ 08:16 PDTToolsReplySQL Assistant truncating View definitionSounds like you are using SQLA 13.10 and the 13.10 ODBC driver. There is an issue with the ODBC driver prior to the 13.10.05 release that causes this behavior. You can either update to the latest r...
11303 Feb 2011 @ 09:31 PSTDatabaseReplyResponse Time, CPU Disk Ratio.Your Database Administrators have configured a rule (or rules) using Teradata Dynamic Workload Manager that your query exceeds. In this case there is a rule in place where the response time and rat...
11203 Feb 2011 @ 07:50 PSTGeneralReplyPerformance Tuning BasicsI would suggest spending some time reading Carrie Ballinger's blog posts on Statistics Collection found here on the Developer Exchange: http://forums.teradata.com/blog/carrie/ Carrie's insight s...
11110 Dec 2010 @ 07:32 PSTDatabaseReplyUsing result set in a queryWhy not use a derived table, volatile/temporary table, or view that you join into your query
11010 Dec 2010 @ 07:28 PSTDatabaseReplyTeradata Security PatchingYou will want to talk to your Teradata CSR regarding the details of your current maintenance patch release for the RDBMS and for the operating system of the Teradata system itself. I'm not aware of...

Pages