Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2013 @ 18:35:12 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Difference between ARCMAIN format and Universal format
From:   Dave Wellman


The quick answer to your question is "chalk and cheese" (but that may only make sense to people from the UK!).

They are completely different.

An ARCMAIN backup file:

- is not intended to be read by anything other than ARCMAIN

- contains data in 'internal' format, i.e. how it is stored in the database, so a DATE field is in the backup file as a 4 byte integer

- retains compression

- (probably) retains encryption/encoding if you're using tools which do that to your data

- the dat ais transferred a block at a time rather than nominally row at a time

The 'universal format' basically contradicts all of the above.

Does that help?



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020