The COPY statement can also load data from fixed-length records without any delimiters in or between the data. In addition, numeric items in the file can be stored in true binary format. For example, the value 256 can be stored in a 2-byte integer instead of 3 characters. The order header file has the following record layout:

The data type formats for each of the fields is as follows:

(2-byte int) (8 chars) (2-byte int)
(35 chars) (1 char)

In this case, you code the COPY statement to load the header table as follows:

It is also possible to copy data from files that contain both fixed and variable-length fields.