SQL data types supported by FTP

FTP access to SQL supports the following data types:

DATE
TIME
TIMESTAMP
VARCHAR (variable length, up to 254 characters)
CHAR (fixed length, up to 254 characters)
DECIMAL
INTEGER (full word)
SMALLINT (half word)
FLOAT (single or double precision)
LONG VARCHAR (VARCHAR(n), where n is greater than 254)
GRAPHIC
VARGRAPHIC
LONG VARGRAPHIC

Mixed data (double-byte character set and single-byte character set) is supported in CHAR, VARCHAR, and LONG VARCHAR data types, but column alignment in the output file might not be maintained.