SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

A-58

APPENDRESTART Command

APPENDRESTART is an SQLCI utility that recovers from an interrupted APPEND

operation and completes the APPEND operation. The APPENDRESTART utility

restores the target table to its original state (before the APPEND operation began).

APPENDRESTART proceeds with the APPEND operation, adding data to the end of

the target table. You should use the APPENDRESTART command only after an

APPEND operation is interrupted by a processor or process failure, or other ungraceful

termination.

in-file

is the name (or equivalent DEFINE) of the table or file from which to append data.

in-file can be a Guardian process, device (such as a terminal or tape),

unstructured disk file, Enscribe file, or SQL table. in-file must be identical to the

in-file specified in the interrupted APPEND command from which this

APPENDRESTART command is recovering. This match is checked only for disk

files or tables.

out-file

is the name (or equivalent DEFINE) of an existing entry-sequenced or key-

sequenced SQL table to which to append data. Neither type of file can have

indexes. out-file must be identical to the out-file specified in the interrupted

APPEND command from which this APPENDRESTART command is recovering.

recovery-file

is the name (or equivalent DEFINE) of a disk file APPENDRESTART uses to

restore out-file to its original state. RECOVERYFILE is a required parameter.

recovery-file must be identical to the recovery-file specified in the

interrupted APPEND command from which this APPENDRESTART command is

recovering.

If APPENDRESTART is successful, it purges recovery-file.

append-option

is one or more options that configure the APPENDRESTART operation. The

options included in append-option must be identical to those specified in the

interrupted APPEND command from which this APPENDRESTART command is

recovering. For more information about append-option, see APPEND

Command on page A-52.

APPENDRESTART in-file, out-file,

RECOVERYFILE recovery-file

[ [,] [append-option] ] ... ;