File Formats

Previous Next

The file formats supported for external sets are FIXED, FIXEDVLE, VARIABLE, CSV.




Other settings

In addition to the file format settings, a number of other settings can affect the exact look of data in an export file:

For each external set element, the data type determines a number of output aspects. For example, if a field in a VARIABLE file format corresponds to an external set element with the NUMBER data type, then the value will not be surrounded by quotes. There is a wide choice of data types, and not all of them are supported by all platforms. For more information, see the lists of supported data types for the various RDBMS platforms in the USoft Definer Help (look for the index entries for "data types").

Depending on the data type and file format, the data length setting may have an effect on the spacing between fields in the file. Generated data length is derived from domain specifications, but can be changed manually for each external set element.

Formats sch as date formats are derived from IO Format specifications (at domain level), but these can also be changed manually for each external set element.

See also

FIXED File Format

FIXEDVLE File Format

VARIABLE File Format

Comma-Separated Values (CSV) File Format

Record Separators