Connect CDC SQData

The OS function executes a command that can be issued from a UNIX / Windows command prompt on multiplatforms or from a TSO command on z/OS.  Connect CDC SQData waits for the command to complete and then continues processing. This function is generally used to execute external procedures (i.e. UNIX shell scripts, Windows BAT files, z/OS CLISTS / REXX execs) from the  Connect CDC SQData Integration Engine.

Category

Specialized

Syntax

OS('command_text' )

 

Parameter Descriptions

command text  -  Any command that can be issued from a UNIX or Windows command prompt. Note that the command text must be enclosed in single quotes (').

Example

If the value of source field SRC_FLD1 is an A, issue an UNIX command to execute a shell script named FTP.sh

IF SRC_FLD1 = 'A'

{

   OS('FTP.sh')

}

As the second step within an  Connect CDC SQData script (using the UNION command), issue a command to start a new  Connect CDC SQData Integration Engine using the command named ENGINE.BAT. This script is run from the Windows platform.

UNION

   OS('ENGINE.BAT)

FROM NOTHING;