#DateForumTypeThreadPost
32418 Jan 2011 @ 06:17 PSTDatabaseReplyNULL handlingThat's standard SQL behavior. Read about "three-valued logic" in any basic SQL textbook. The only predicate operator that returns true with a null operand is IS NULL.
32318 Jan 2011 @ 11:02 PSTDatabaseReplyApplications configurationTeradata clients are normally configured to connect to any available node of the target system. A host naming convention is used to associate the the network host names of the nodes with the Terad...
32218 Jan 2011 @ 10:34 PSTUDAReplyHow to take backup of a Teradata Database?Read about the Archive/Recovery Utility in the Teradata Tools and Utilities documentation.
32111 Jan 2011 @ 08:15 PSTDatabaseReplyDifference in Inserting '1 ' and '1' More generally, trailing blanks are not significant in comparisons of character string values. That is required for ANSI/ISO standard SQL conformance.
32007 Jan 2011 @ 03:52 PSTDatabaseReplyDBS CRASHED OR SESSIONS RESETAre you sure bteq is not installed on your VM? I believe the Teradata Express Edition for VMWare comes with a full suite of client tools. They should be in the /usr/bin directory.
31907 Jan 2011 @ 03:45 PSTDatabaseReplyDBS CRASHED OR SESSIONS RESETIf your Teradata VM is running in NAT mode, it is sharing the host machine's IP address, so you will need to configure port forwarding on the host machine. Port 1025 should be set to forward to th...
31810 Dec 2010 @ 05:31 PSTToolsReplyUpdates for Express?Customers of the licensed versions pay for regular maintenance, which includes access to patch releases, through their license and subscription fees. TD Express, on the other hand, is free. You g...
31710 Dec 2010 @ 05:22 PSTDatabaseReplyPrivacy Enabled Data CompressionI assume you meant to ask about encryption, not compression. Compression is intended to reduce space usage but does not provide privacy protection. Encryption is used to protect privacy or to...
31602 Dec 2010 @ 11:07 PSTGeneralReplyTDPUSERPUBLIC is not a real user. It serves as a dummy key for public rights in DBC.AccessRights. TDWM and TDWSTAGE must be for the Teradata Workload Manager, but I don't know how they are used.
31501 Dec 2010 @ 12:11 PSTToolsReplyTpump and LoadingTpump and other load utilities have various restart options. If you specify the ROBUST option with Tpump, it will do fine-grained checkpointing and be fully restartable with either set or multiset...
31430 Nov 2010 @ 05:22 PSTGeneralReplyTDPUSERTDPUSER is created automatically during system installation. It may be used by the TDP on channel-attached systems to create sessions for internal administratiive purposes.
31330 Nov 2010 @ 12:29 PSTConnectivityReplyMainframe to Teradata Express (winodws) connectivityNo, that is not possible. Teradata Express supports network-attached clients only.
31205 Nov 2010 @ 10:59 PDTCloud ComputingReplyLoading data to TD Express (Windows or Linux) using Ab InitioI said you *may* need a static IP address. I am not certain that it is necessary, but it is the standard practice. I find that I can get by with DHCP with the clients/tools that I use. If you ha...
31103 Nov 2010 @ 10:45 PDTCloud ComputingReplyLoading data to TD Express (Windows or Linux) using Ab InitioAll the clients or applications that work on your production system should work on TD Express--subject, of course, to the obvious capacity limits. If using the VMWare edition, set the network conn...
31029 Oct 2010 @ 06:15 PDTToolsReply<Internal Session> blocking users and causing deadlockI believe that is considered a feature, not a bug. The locks are left in place so that you can restart the archive job from the point where it left off. A restart of the database does not clear t...
30905 Oct 2010 @ 12:21 PDTDatabaseReplyStored Procedure language...Read "SQL Stored Procedures and Embedded SQL", which you can download at the following link: http://www.info.teradata.com/edownload.cfm?itemid=102320056
30804 Oct 2010 @ 05:43 PDTDatabaseReplyRestore a single Database from a .DAT File(Taken backup of Multiple DBs in .DAT file)...Yes. You can restore any individual table or database from the archive without restoring eveything that is contained in the archive.
30704 Oct 2010 @ 05:37 PDTDatabaseReplyPPINo, it doesn't work that way. Since the partition ID is part of the row ID, it is only necessary to ensure that the rest of the row ID is unique within the partition.
30630 Sep 2010 @ 10:37 PDTGeneralReplyWhat role does last 16bit play in 32 bit ROW HASHNo. The table ID is a separate 32-bit number.
30529 Sep 2010 @ 06:19 PDTGeneralReplyWhat role does last 16bit play in 32 bit ROW HASHActually, in recent versions the first 20 bits of the hash are used to select the AMP. The entire 32-bit hash is used to determine the physical placement of the row within the hash. Thus rows wit...
30417 Sep 2010 @ 09:16 PDTGeneralReplyCLI Development on SLES VMThe native visual debugger on Linux is the Emacs gdb mode. Emacs provides the visual front end to gdb. Both Emacs and gdb are included in the SUSE SLES10 distribution.
30303 Sep 2010 @ 11:26 PDTGeneralReplyTeradata equivalent Query of SQL ServerWhile it is true that COALESCE is equivalent to ISNULL, writing a completely equivalent query is not quite that easy. Teradata does not allow "select top n" in a subquery. Even conceptually, "se...
30231 Aug 2010 @ 03:47 PDTDatabaseReplySpool treatment for DISTINCT versus GROUP BYYou might find it mentioned in the Release Summary for Teradata 13. The item "Group By and Distinct Performance Equivalence" is probaby the enhancement you have in mind.
30130 Aug 2010 @ 01:54 PDTDatabaseReplyuse of coalesce in Tera dataYou can use a scalar subquery as an argument to coalesce, but "SELECT TOP n" is not allowed in a subquery.
30019 Aug 2010 @ 11:05 PDTDatabaseReplyMerge vs Insert-SelectCurrently, the only case where an insert-select is executed without using an intermediate spool is when the source and target tables have EXACTLY the same column types. This is due to the fact tha...

Pages