Connect CDC SQData

CALLPROC

Invokes a predefined SQData procedure (PROC)

CASE

Evaluates a series of Boolean expressions initiating an action on the first True condition or when all conditions are False

CONVERT_CCSID

Convert an individual source field from one encoding scheme (CCSID) or code page to another

DB2QUAL

Returns the qualifier of the DB2 table currently being processed

DB2TBLNAME

Returns the name of the DB2 table currently being processed

DSDIR

Returns the name of the directory in which a file type datastore resides

DSNAME

Returns the name of the physical datastore file

FLDMAX

Returns the largest value in a set of values

FLDMIN

Returns the smallest number in a set of numeric values

FULLKEY (IMS Fullkey)

Returns the fully concatenated key of the current IMS segment

HASH_LOAD

Retrieve a row from a hash table

HASH_REMOVE

Remove a row from a Hash Table

HASH_STORE

Add a row or update an existing row in a Hash Table

IF / ELSE

Two functions that work together to perform conditional processing based on evaluation of one or more values

IMSDBNAME

Returns name of the IMS database that is currently being processed

IMSSEGNAME

Returns name of the IMS segment that is currently being processed

LOOP

Executes a function or group of functions a specified number of times

MAP

Perform source to target data mapping within a function or nested set of functions

MAP_BEFORE

Performs source to target data mapping of Before Key fields ONLY

MD5SUM_JSON

Calculate the md5 hash of the given input

NORM

normalize the contents of a source datastore record

NULL

Sets a variable or target field to a null value

OS

Executes a command from a UNIX / Windows command prompt or TSO on z/OS

OUTMSG

Display the contents of a text string, source field, variable or the result of a function

READ

Suspends and resumes the reading of records from the primary source datastore

RECIDENT

Identifies the specific record being processed when a source datastore has multiple record types

RID

Returns the relative record number in a source datastore

SETIMAGE

Select the Image (BEFORE or AFTER) to be used as the source (or target) datastore

TERMINATE

Stops an engine with a user defined return code.