Deletes the schedule definition associated with a transfer definition. You can delete a schedule definition only when the associated transfer is in the suspended state. Refer to the STOP TRANSFER statement for information about how to suspend a transfer. If you issue a START TRANSFER statement after deleting the schedule, the transfer will be placed in the unscheduled state.
1 – Format
(B)0[m[4mDELETE[m [4mSCHEDULE[m qq> FOR qqq> transfer-name qqqqqq> .
1.1 – transfer-name
Identifies the transfer whose schedule is to be deleted. The transfer-name parameter is required.
2 – More
You must execute the DELETE SCHEDULE statement outside of the scope of a transaction. If you issue this statement when a transaction is outstanding, Replication Option returns an error message. If a transfer has a schedule definition, DELETE TRANSFER also deletes the corresponding schedule definition. If you want to delete a transfer schedule, the schedule definition must be associated with your UIC.
3 – Example
This example places the NH_EMPLOYEES transfer in a suspended state and then deletes the associated schedule. RDO> STOP TRANSFER NH_EMPLOYEES RDO> DELETE SCHEDULE FOR NH_EMPLOYEES.