Search results for query: *

As for your second post - there are times when one may not want to compress a null and therefore it is left up to the DBA to decide. Savings is achieved on nulls because the fixed length bytes of nothing is no longer stored in the row. However, there is a null presence bit used to indicate the...

There are a number of methods that could be employed but let me note the most common and easiest. 1.) If the table is relatively small < 10 MB then I would use BTEQ export. The syntax is a simple as ... .EXPORT DATA FILE=filename select * from tablename; 2.) If the table is larger then I...

The methodologies to translate your logical model into a physical model are far too lenghty to describe in this type of a forum. I would suggest that you download some of the documentation from the NCR technical pubs website at www.info.ncr.com. One of the manuals of interest to your search...

I believe that you meant a function similar to the CEIL function in Oracle and opposite to the FLOOR function. The CEIL function provides the smallest integer that is >= to a specific value. For instance, CEIL(2) = 2 CEIL(1.3) = 2 CEIL(-2) = -2 CEIL(-2.3) = -2 Is this what you were...

These types of servers are generally sold through a secondary market. I have heard of a firm called ANT that does this sort of business. They can be found at http://www.ant91.com/teradata.htm. I don't know anything about their reputation but it might be someplace to check out. Just to give...

There might be some third party tools to directly connect from Teradata to DB2 and move the data across. I cannot provide you any details on that aspect. I suspect that there is not much out there since this is typically a one shot deal. Therefore, most people take the straight-forward...

James, I only wanted to caution you against making the common mistake of applying fallback on top of the protection that you are likely to already have with RAID-5. The critical issue is that you should consider the availability requirements and costs relative to the benefits. Rather than...

When using Microsoft Access 2000 to link to a Teradata system table (DBC.AccLogTbl) all I receive in the result set after executing the query is the constant &quot;#Deleted&quot; in each row and column. I am using the Teradata demo software and therefore using the default Teradata ODBC driver...

James, A Vproc (virtual processor) is a generic term for VAMP and VPE. VAMPs are virtual AMPs and VPEs are virtual parsing engines. VPEs are basically responible for all communications to the client, such as, receiving SQL requests, parsing the SQL, optimizing, dispatching the SQL steps, and...