Valid for

Extract, Replicat

Description

Use SPECIALRUN for one-time batch processing. SPECIALRUN tasks process activity that occurs within a time period, such as the changes logged between 8 a.m. and 3 p.m. on a particular date. Checkpoints are not recorded so the process can not be restarted from an intermediate processing point. An Extract SPECIALRUN process can read from Oracle GoldenGate or TMF audit trails; a Replicat from Oracle GoldenGate trails.

SPECIALRUN for Extract

You can specify EXTTRAILSOURCE or EXTFILESOURCE for Extract to read data from Oracle GoldenGate trails rather than TMF audit trails.

SPECIALRUN has the following dependencies:

• When you specify SPECIALRUN, you must also specify the BEGIN and END parameters.

• SPECIALRUN must precede EXTFILE, RMTFILE, EXTTRAIL or RMTTRAIL entries.

Syntax

SPECIALRUN 
[, EXTTRAILSOURCE trail_name] 
[, EXTFILESOURCE trail_file_name]

EXTTRAILSOURCE trail_name

The name of the Oracle GoldenGate trail to use as the data source.

EXTFILESOURCE trail_file_name

The name of the Oracle GoldenGate trail containing the single file to use as the data source.

Examples

Example 1   

SPECIALRUN EXTTRAILSOURCE $data1.ggsdat.et

Example 2   

SPECIALRUN EXTFILESOURCE $data3.etdat.datfile1

SPECIALRUN for Replicat

For Replicat you must specify EXTTRAIL, RMTTRAIL, EXTFILE or RMTFILE with a SPECIALRUN.

Replicat always uses BEGIN and END to determine when to start and stop processing for a SPECIALRUN. If nothing is entered for BEGIN, the process will start with the first record. If nothing is entered for END, the process start time will be used to determine the limit of the records to process.

Syntax

SPECIALRUN 

Example

The following is an example of a Replicat parameter file that would be run from a TACL prompt to load records from the file GGSINI.ECUSTMER on the target system to the GGSTAR.TCUSTMER table on the target. The GGSINI.ECUSTMER file was previously loaded to the target by an Extract one-time run.The data definition for GGSSOU.ECUSTMER stored in GGSDEF.ECUSTDEF is used to map the structure of the source records to the target.

SPECIALRUN
END RUNTIME
SOURCEDEFS \B.$DATA3.GGSDEF.ECUSTDEF
EXTFILE \B.$DATA3.GGSINI.ECUSTMER
MAP \A.$DATA1.GGSSOU.ECUSTMER,
TARGET \B.$DATA3.GGSTAR.ECUSTMER;