Re: Fastload from a mainframe (usage comp - format)
I assume you are referring the COMP data type in IBM COBOL, which is a signed binary integer in twos-complement form. It may be 16, 32 or 64 bits wide. In Teradata, it should be declared as BIGINT (64 bits), INTEGER (32 bits) or SMALLINT (16 bits) depending on the width.
The second field is given problems during fastload. This amount is a decimal field (11 positions before and 2 positions after the decimal point, with a virtual decimal point). Total number of bytes: 8 bytes.