Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Mozc
  • Order by date
  1. Mozc

    Table size, database space and archiving

    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...
  2. Mozc

    How do you unload Teradata tables to a datasets?

    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...
  3. Mozc

    Data Modeling in Teradata

    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...
  4. Mozc

    Is there a TOP function or equivalent in Teradata?

    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...
  5. Mozc

    NCR 4800 Server

    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...
  6. Mozc

    DB2 to Teradata.

    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...
  7. Mozc

    data protection

    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...
  8. Mozc

    Microsoft Access to Teradata via ODBC

    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...
  9. Mozc

    data protection

    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...

Part and Inventory Search

Back
Top