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";