Operating System Native Data Types

Data for some data types is stored in native operating system binary format and can be written to data files directly in that format. SAP Sybase IQ reads the respective number of bytes directly into the associated data types without conversion.

By default, VARCHAR and VARBINARY columns are read in as many bytes as specified by LOAD TABLE column-spec.

Related concepts
IQ Binary Load Format and Load Efficiency
DATE
TIME
TIMESTAMP
NUMERIC and DECIMAL
NULL Value Loads