6. QUEL and EQUEL Statements : Copy Statement--Copy Data : Copy Statement Parameters : Unformatted Copying
 
Share this page                  
Unformatted Copying
To copy all rows of a table to a file using the order and format of the columns in the table, omit the column list from the copy statement. This operation is referred to as an unformatted copy. For example, to copy the entire "employee" table into the file "emp_name", issue the following statement:
copy table employee () into 'emp_name';
You must include the parentheses in the statement, even though no columns are listed. The resulting binary file contains data stored in column binary formats. To load data from a file that was created by an unformatted COPY INTO, use an unformatted COPY FROM.
VMS: Bulk copy always creates a binary file.