Connect CDC SQData

Connect CDC SQData functions are very similar to functions in a spreadsheet. Each function performs a very specific type of operation based on one or more input parameters to produce a new output value.

Syntax

function_name (parameter [, parameter])

 

Keyword and Parameter Descriptions

function_name - The name of the SQData function. May be specified in either upper or lower case however with the exception of functions that control the flow of logic like "if", "else", "case", "and" and "or" they are frequently capitalized to clearly distinguish them from variables, source and target columns and fields.

parameter - One or more arguments required by the function. Refer to the specific function for a description of the required and/or optional arguments required by that function. Parameters can also be another function. Nested functions are described in more detail below.

Samples

Here are some simple (non-nested) functions that may appear within a command script. Examples of each supported function can be found in the All Functions section below.

ABS(numeric_field)

CDCOP(<source_datastore>)

C2X(character_string)

DAYOFWEEK()

DB2TBLNAME(<source_datastore>)

STRING(<data_string> [, <data_string>])

TRANSLATE(data_string, original_character, replacement_character)

 

Note, Connect CDC SQData also supports something called a Function Procedure or Function PROC. Similar in concept to a normal function, they permit any combination of Functions to be performed including conditional logic based on a set of one or more input parameters and any number of "local variables".  Unlike normal functions a Function PROC can return one or more parameters as output to the calling procedure.