5. Populating Tables : Bulk Copying
 
Share this page                  
Bulk Copying
A COPY FROM statement that performs a bulk copy can include the following additional WITH-options:
[WITH [standard-with-clauses]
[, ALLOCATION = n] [, EXTEND = n] [, ROW_ESTIMATE = n]
[, FILLFACTOR=n] [, MINPAGES=n] [, MAXPAGES=n]
[, LEAFFILL=n] [, NONLEAFFILE=n]]
If the file is formatted, you must specify columns in the column list as described for reloading formatted data. If the file was created with unformatted copy, use an empty column list.
If you specify any of these additional bulk copy WITH-options, but the target table cannot be bulk-copied, the COPY statement will be rejected with a runtime error.