#DateForumTypeThreadPost
39904 Oct 2011 @ 11:17 PDTDatabaseReplySUM(CurrentPerm) > SUM(MaxPerm) for one of the VPROCS Yes, that is possible.  There are several possible scenarios that could produce that result, and there are good reasons why we allow it to happen. The most common case seems to be when a da...
39827 Sep 2011 @ 12:38 PDTDatabaseReplyHow to convert CURRENT_TIMESTAMP into UTC timestamp? Prior to TD 13.10, time and timestamp values are stored in the database based on system local time.  In 13.10, that behavior can be changed by setting the TimeDateWZControl system...
39726 Sep 2011 @ 02:19 PDTUDAReplyUnique Primary Index restricted in PPI This was discussed to death some time ago on another thread in this forum: http://forums.teradata.com/forum/database/ppi-0 The short answer is that it would be too expensive to enforce u...
39622 Sep 2011 @ 11:54 PDTDatabaseReplyWhere are system reboots tracked? There is no DBC table that tracks reboots or DBS restarts. 
39522 Sep 2011 @ 11:37 PDTDatabaseReply'Materialized View' in Teradata? For another alternative, consider the temporal table feature, which was introduced in release 13.10.  It allows you to define tables with a transaction time dimension.  Then you can sp...
39421 Sep 2011 @ 12:52 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10 After consulting a more expert person, I have learned that it is indeed possible to create a value-ordered join index.  Here is an example: create table t1 (a1 int, b1 int); create ...
39319 Sep 2011 @ 11:13 PDTDatabaseReplyHow to get all the dbc.% tables in Teradata All DBC tables are system tables.  You can read about them in  the Teradata documentation set.  See the volumes titled "Data Dictionary" and "Data Dictionary Quick ...
39214 Sep 2011 @ 01:03 PDTDatabaseReplyCPU utilization by a query The reporting unit of measure for CPU times is seconds. AMPCPUTime is the sum of the CPU usage for all participating threads on all participating AMPs.  The CPU time is actuall...
39114 Sep 2011 @ 11:33 PDTDatabaseReplyVALUE ORDERED PRIMARY INDEX TD13.10 Teradata does not support a valued-ordered primary index.  A value-ordered index can be defined only as a secondary index on either a base table or a join index.  A primary index&...
39007 Sep 2011 @ 01:12 PDTDatabaseReplyTrigger calling StoredProcedure Teradata supports the CALL statement as a triggered action statement only in AFTER triggers.  
38919 Aug 2011 @ 11:21 PDTDatabaseReplyListing block level compressed tablesI have been told that in TD 13.10, the SHOWBLOCKS command in Ferret prints a "#" character next to the tables that have compressed blocks, but I can't attest to this personally since I don't have a...
38817 Aug 2011 @ 02:13 PDTDatabaseReplyMax value held by COUNT (*)The Teradata documention is your friend here. See the volume "SQL Functions, Operators, Expressions, and Predicates" in the SQL documentation set. The result type of COUNT(*) depends on the ses...
38716 Aug 2011 @ 01:03 PDTConnectivityReplyConnecting to Teradata Express for VMware through local networkSince you can't even ping the IP address, there must be a problem with your network configuration. The "192.168.*.*" addresses are typically not visible from outside the local subnet. How did you...
38616 Aug 2011 @ 10:35 PDTDatabaseReplyHow to export data to MSACCESS (.accdb) file using BteqAs I said, you can export from Teradata directly into MS Access. You don't need BTEQ to do that. As I understand it, you only need to point MS Access to your Teradata ODBC data source or .NET pro...
38516 Aug 2011 @ 08:19 PDTDatabaseReplyHow to export data to MSACCESS (.accdb) file using BteqWhy use BTEQ? That seems the wrong tool, considering that MS Access can connect to Teradata and get results back directly.
38415 Aug 2011 @ 10:00 PDTConnectivityReplyConnecting to Teradata Express for VMware through local networkYou will need to change the VMWare network configuration for the VM. As shipped, it is configured for NAT mode. See the forum thread below for details: http://forums.teradata.com/forum/cloud-...
38327 Jul 2011 @ 06:08 PDTExtensibilityReplyAdding UDF_ReplaceStr to more than 4 columns of an existing query throws error SELECT Failed. 3577: Just a guess: The answer may have something to do with the result type of your UDF. The parser calculates the result row size using the maximum size of the result column values. Suppose the de...
38227 Jul 2011 @ 11:04 PDTConnectivityReplyName not in HOSTS file error - LinuxThe problem you encountered is not specific to Linux. Adding the host name to the /etc/hosts file will not, by itself, fix the problem. The server name (called "tdpid" in the BTEQ documentation)...
38126 Jul 2011 @ 12:06 PDTGeneralReplyMload vs Fastload in rejecting the duplicatesI believe Fastload silently discards duplicate rows. They don't go to the error table. Many of the differences between FastLoad and MultiLoad are due to the fact that MultiLoad loads by way of ...
38025 Jul 2011 @ 12:18 PDTDatabaseReplyCalling Only Closed RecordsUse a query form like the following to select all closed rows. NONSEQUENCED TRANSACTION TIME SELECT ... WHERE END(TT) IS NOT UNTIL_CLOSED; See Chapter 9 "Period Functions and Operators" in ...
37922 Jul 2011 @ 11:07 PDTToolsReplyonline archive feature in Teradata 13Yes, regular DML operations, as well as the MultiLoad and Tpump utilities, may execute and commit concurrently with the archive operation. Undo information is captured into a special log that is a...
37822 Jul 2011 @ 10:33 PDTDatabaseReplyBack up of objectsYou back up whatever you can't recreate by other means in the event of some system failure or local disaster. Typically, you back up at least the DBC database so that you can recover the user...
37721 Jul 2011 @ 10:31 PDTDatabaseReplyHow does Teradata manages UDFSELECT FunctionName FROM DBC.Functions ... If you create the function in the SYSLIB database, it can be referenced by the simple (unqualified) function name from any database.
37619 Jul 2011 @ 11:37 PDTCloud ComputingReplyHow to setup Cloud??I think this explains it: http://xkcd.com/908/
37518 Jul 2011 @ 01:27 PDTGeneralReplyTeradata Express - VMWare 1TB version 13.10 - Frequent CPU spike and Nonresponsive systemI use a VMWare configuration quite similar to the Teradata Express Edition on a daily basis--and have so for years--but I have never seen the phenomenon you describe. The first diagnosis step shou...

Pages