SQL$HELP72.HLB  —  INSERT_FROM_FILENAME, Arguments

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.
Close Help