1 – AS
Syntax options:
AS BINARY | AS CHARACTER VARYING | AS TEXT
Specifies whether the file specified with the FILENAME clause
contains these types of data:
o BINARY
Used to load unformatted data such as images and audio files.
The contents are broken into 512 octet segments during INSERT.
o CHARACTER VARYING
Used to load text but with no terminator. The contents are
written one line to a segment.
o TEXT
Used to load text, a terminator is added to each segment
loaded. The contents are written one line to a segment with
trailing terminators carriage return (CR) and line feed (LF).
2 – FILENAME filespec
The specification for the file that you want to load into the
LIST OF BYTE VARYING column.
3 – INSERT INTO CURSOR cursor-name
The name of the target list cursor to which you want to add a
list segment.