ODXSQL Commands

COPY

COPY source target [WITH options]

The COPY command copies the specified source file into the specified target file.

If the target file exists, it will be overwritten.

It is not necessary to be connected to an environment to use the COPY command.

Case sensitivity on the source file is platform specific. Windows is generally not case sensitive, however, Unix is. For example, to copy a file named tips.htm (lower case):

Windows:

>COPY TIPS.HTM COPYTIPS.HTM
Copied 1 file in 1 directory 8512 bytes

Unix:

>COPY TIPS.HTM COPYTIPS.HTM
File or directory "TIPS.HTM" not found.

Syntax

COPY source target [WITH options]

COPY

Required.

source

Required. File spec of the file to be copied.

target

Required. File spec of the newly created copy.

WITH options

Optional. See list of valid options for the copy command.

top

Example

Unix

[/users/test/files/]$ ls

cust.htm index.htm tips.htm
[/users/test/files/]$ odxsql

>copy tips.htm tips2.htm
Copied 1 file in 1 directory 8512 bytes
>

WINNT

c:\test\files> dir

10/12/01 10:00a <DIR> .
10/12/01 10:00a <DIR> ..
06/19/00 09:38a 9376 cust.htm
05/22/00 04:42p 12324 index.htm
06/16/00 01:21p 8512 tips.htm
3 File(s) ...

c:\test\files> odxsql

>copy tips.htm tips2.htm
Copied 1 file in 1 directory 8512 bytes
>

top

Options

The following options can be applied to the COPY command in a WITH options clause of the COPY statement.

PAGING -- Prompt the user before printing the next page of copied files.

DETAILS -- Print details as each file is copied

RECURSE -- Recurse into subdirectories

DELETE -- Deletes target files if they exist

top