SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-56
APPENDCANCEL Command

Field Conversions
For any APPEND operation, the data type of each source field must be compatible
with the data type of its corresponding target field. The details of data type
compatibility and Enscribe-to-SQL and SQL-to-Enscribe field conversions are
identical for APPEND and LOAD; see Data type compatibility and field conversions
on page L-36 for details.
APPENDCANCEL Command
APPENDCANCEL is an SQLCI utility that recovers from an interrupted APPEND
operation by restoring the target table to its original state (before the APPEND
operation began). APPENDCANCEL deletes any data appended to the target table by
the interrupted APPEND operation. You should use the APPENDCANCEL command
only after an APPEND operation is interrupted by a processor or process failure, or
other unexpected termination.
out-file
is the name (or equivalent DEFINE) of an existing entry-sequenced or
key-sequenced SQL table without indexes whose APPEND is to be canceled.
out-file must be identical to the out-file specified in the interrupted
APPEND command from which this APPENDCANCEL command is recovering.
recovery-file
is the name (or equivalent DEFINE) of a disk file APPENDCANCEL 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 APPENDCANCEL command is
recovering.
If APPENDCANCEL is successful, then it purges the recovery-file.
PARTONLY
You must use the PARTONLY option if PARTONLY was specified in the original
APPEND command from which this APPENDCANCEL command is recovering.
APPENDCANCEL out-file, RECOVERYFILE recovery-file
[ [,] PARTONLY ] ;