Ingres 11.0 | COPY--Copy Data

QUEL Reference Guide > QUEL Reference Guide > QUEL and EQUEL Statements > COPY--Copy Data

Was this helpful?

COPY--Copy Data

Valid in: QUEL, EQUEL

Copies data from a table into a file or from a file into a table.

This statement has the following format:

[##] copy tablename
              ([columnname = format [with null [(value)]]
              {, columnname = format [with null[(value)]]}])
              into | from "filename[, type]"
              [with with-clause]

The with-clause consists of a comma-separated list of one or more of the following items:

on_error = terminate | continue
error_count = n
rollback = enabled | disabled
log = "filename"
row_estimate = n

The following options are valid only for bulk copy operations. For details about these settings, see MODIFY--Change Table or Index Properties. The value specified for any of these options becomes the new setting for the table, and override any settings you have made previously (either using the modify statement or during a previous copy operation).

allocation = n
extend = n
fillfactor = n  (isam, hash, and btree only)
minpages = n (hash only)
maxpages = n  (hash only)
leaffill = n  (btree only)
nonleaffill = n  (btree only)

The copy statement enables you to copy the contents of a table to a data file (copy into) or copy the contents of a file to a table (copy from). The following table briefly describes the valid statement parameters. Details about the parameters are provided in the following sections. For more information and procedures for using the copy statement, see the Database Administrator Guide.

Last modified date: 01/30/2023