The list in Table 151 summarizes Control-M/Analyzer functions by category. Each function and its syntax are described in detail in alphabetical order on the following pages.
Table 151 Control-M/Analyzer String Functions
Function |
Description |
---|---|
FILTER |
Removes all occurrences of specified characters from a data string. |
FILTERW |
Removes one or several occurrences of a string from a data string. |
FIND |
Returns the position of a string within a data string. |
FINDCH |
Returns the position in a data string of the first occurrence of any one of the characters specified in a substring. |
ISNUMBER |
Determines if its argument is numeric. |
LENGTH |
Determines the number of characters in a data string. |
REPLACE |
Replaces a specified character string with another character string. |
SUBSTR |
Extracts a portion of a data string. |
TOLOWER |
Converts a data string to lowercase characters. |
TOUPPER |
Converts a data string to uppercase characters. |
TRIMB |
Removes (trims) trailing blanks from a data string. |
TRIML |
Removes (trims) leading blanks from a data string. |
WORD |
Returns the nth word (substring) in a string. Delimiters can be specified as word separators. |
WORDNUM |
Returns a count of the number of words in a string. |
Table 152 Control-M/Analyzer Mathematical Functions
Function |
Description |
---|---|
ABS |
Calculates the absolute value of its numeric argument. |
INT |
Returns the integer portion of its numeric argument. |
MAX |
Returns the largest value in a list of numbers. |
MIN |
Returns the smallest value in a list of numbers. |
MOD |
Returns the remainder that results when its second argument is divided by its first argument. |
POW |
Calculates the result of raising its first argument to the power of its second argument. |
SQRT |
Returns the square root of its numeric argument. |
SUM |
Calculates the sum of the variables the names of which match a specified pattern (mask). |
Table 153 Control-M/Analyzer Variable Functions
Function |
Description |
---|---|
DBINFO |
Returns information about a Database variable. |
HOWMANY |
Returns the number of variables the names of which match a specified pattern. |
ISVAR |
Determines if its argument currently exists as a Control-M/Analyzer Local or Database variable. |
NEXTVAR |
Returns the next variable in a set of variables that match a specified pattern (mask), thus enabling Control-M/Analyzer to scan the entire set. |
Table 154 Control-M/Analyzer Balancing Functions
Function |
Description |
---|---|
DATASTAMP |
Returns the unique identifier of a data source specified by a previously executed EXECUTE block. |
LINECOUNT |
Returns the number of lines of a data source specified by a previously executed EXECUTE block. |
TOLER |
Determines if the percentage difference between two numbers is less than or equal to the specified tolerance percentage. |
Table 155 Control-M/Analyzer Date Functions
Function |
Description |
---|---|
CALCDATE |
Calculates a date by adding or subtracting the number of days in the second argument to or from the date in the first argument. |
CONVDATE |
Modifies a date format. |
GETJUL |
Returns the Julian calendar date of its date argument. |
GETWDAY |
Returns the day of week of its date argument. |
Table 156 Control-M/Analyzer JCL Functions
Function |
Description |
---|---|
DDINFO |
Returns information about a data set that is referenced by a specific DD statement. The information is obtained from the JCL. |
DDNUM |
Returns the number of data sets concatenated in a specific DD statement. The information is obtained from the JCL. |
Table 157 Control-M/Analyzer Data set Functions
Function |
Description |
---|---|
ISDSN |
Determines if a data set exists. |
ISMEM |
Determines if a member exists in a specified library. |
ISSYSOUT |
Determines if a SYSOUT exists |
MEMLINES |
Returns the number of lines in a specific member. |
Table 158 Control-M/Analyzer Miscellaneous Functions
Function |
Description |
---|---|
NOT |
Negates the value of its logical argument. |
Parent Topic |