Please enable JavaScript to view this site.

SQData functions must adhere to the following guidelines:

•Functions may be used only within an SQData SELECT command.

•Parameter values of functions are specified between opening and closing parenthesis and can be represented by one or more of the following:

1.A field/column within a source datastore.

2.A literal value enclosed in single quotes (i.e.'MUSTANG').

3.The value of a previously defined global or local variable whose value has been initialized or set in the script.

4.The result/output of another SQData function.

5.Nothing - Functions that do not require a parameter value do require the open close parenthesis ().

•Mathematical functions require that all values be numeric.

•Functions can be nested.

•Boolean functions return a true (1) or false (0) condition. If the result of a Boolean function is true, then any functions specified within the Boolean function are executed. Otherwise, the functions are not executed.

•Certain data string functions, such as C2X and X2C, will translate the data string into the code page in which the operation takes place. For example, if a translation is performed on a z/OS platform, the result of a function will be in EBCDIC format. If the translation is performed on a UNIX platform, the result will be in ASCII format.