Actian X 11.2 | Load Data with COPY VWLOAD Statement

Database Administrator Guide > Database Administrator Guide > Loading Data into X100 Tables > Load Data with COPY VWLOAD Statement

Was this helpful?

Load Data with COPY VWLOAD Statement

The COPY...VWLOAD statement copies the contents of a file to a table using the VWLOAD operator. This operation is like using vwload -‑cluster on the command line, except that the load can be done from within a multi-statement transaction instead of in a separate session.

The vwload --cluster option speeds up loading by parallelizing some of the processing steps.

To use this option, multiple input files are required and they must reside on the server, not the client. Parallelization works best when input files have (almost) the same size.

For example, bulk load the data from multiple files into the region table. Columns in the data file are delimited with a vertical bar, records are delimited by a new line, and null values are identified as NULL:

COPY region() VWLOAD FROM 'path/to/data/mytable_1.txt', 'path/to/data/mytable_2.txt' WITH INSERTMODE=BULK, VWLOAD_PARAMS=('-f', '|', '-r', '\n', '-n', 'NULL'), WORK_DIR = '/home/users/temp'

Last modified date: 04/03/2024