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 and Description
| Parameter | Description |
|---|---|
| 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;