Loading Data Interactively

OpenText recommends using the COPY statement in script files, as described in Using Load Scripts. You can also load data interactively by piping a text file to vsql and executing a COPY (or COPY FROM LOCAL) statement with the standard input stream as the input file.

For example:

$ cat fact_table.tbl | vsql -c "COPY FACT_TABLE FROM STDIN DELIMITER '|' DIRECT";
$ cat fact_table.tbl | vsql -c "COPY FACT_TABLE FROM LOCAL STDIN DELIMITER '|' DIRECT";