Please enable JavaScript to view this site.

The following table summarizes the  Apply Engine commands, organized by command type.

Command

Description

Environment Commands

COMMIT

Specifies the commit frequency for datastores that support commit operations

JOBNAME

Specifies a name for an  Apply Engine instance

OPTIONS

Specify global script behavior options

RDBMS

Describes the connection information for a relational database (RDBMS)

REPORT

Controls the file name and frequency of the Engine runtime report

Data Definition Commands

BEGIN | END GROUP

Create a "named" group of DESCRIPTIONS to simplify specification of DATASTORE

CREATE RDBMS CURSOR

Defines a database "Cursor" providing granular control of the retrieval and update of single rows or sets of data in any  supported Relational datastore.

DATASTORE

Describes the type, method of access, physical name and other characteristics for  both source and target datastores

DESCRIPTION

Describes the logical/physical structure/layout of the data in a source or target datastore

Field Specification Commands

DATEFORMAT

Specifies the date format for Oracle and DB2

DECLARE

Declares a user-defined variable

EXTTYPE

Specifies the semantic of the data in a source field

GROUP BY

Groups source data records based on a source data field(s)

INITIALIZE

Initializes a target field to a constant value

INVALID

Specifies the value to use in place of an invalid value of a numeric or character source field

LABEL

For XML structures, specifies the text string for a tag on an XML data record

RETYPE

Changes the data type of a source field, overriding the defining data structure

Processing Commands

APPLY

Write to the target datastore

AUTOMAP

Automatically map a source to an identical or nearly identical target description

PROCESS INTO

Processes one or more target datastores based on the action specified for each datastore (Change or Insert)  Options include inserting records that if they are unavailable for update

CREATE PROC

Defines a called procedure (PROC) to perform mapping, business logic

REPLICATE

Automatically map the source description to an actual or implied target description and APPLY (write) to the Target datastore

SELECT

Reads records for a source datastore

UNION

Concatenates multiple SELECT commands allowing for multi-step scripts