The rest of the functions can be denominated as miscellaneous. They are the functions listed below.
Important | |
---|---|
Remember that the object notation (e.g., For more information about object notation see Functions Reference. |
<any type> iif(
boolean con, <any type>
iftruevalue, <any type>
iffalsevalue)
;
The iif(boolean, <any type>, <any type>)
function accepts three arguments: one is boolean and two are of
any data type. Both argument data types and return type are the
same.
The function takes the first argument and returns the second if the first is true or the third if the first is false.
boolean isnull(
<any type> arg)
;
The isnull(<any type>)
function takes one
argument and returns a boolean value depending on whether the
argument is null (true) or not (false). The argument may be of any
data type.
Important | |
---|---|
If you set the Null value property in metadata for any
For example, if See Null value for detailed information. |
<any type> nvl(
<any type> arg, <any type> default)
;
The nvl(<any type>, <any type>)
function
accepts two arguments of any data type. Both arguments must be of
the same type. If the first argument is not null, the function
returns its value. If it is null, the function returns the default
value specified as the second argument.
<any type> nvl2(
<any type> arg, <any type>
arg_for_non_null, <any type>
arg_for_null)
;
The nvl2(<any type>, <any type>, <any type>)
function accepts three arguments of any data type. This data type
must be the same for all arguments and return value. If the first
argument is not null, the function returns the value of the second
argument. If the first argument is null, the function returns the
value of the third argument.
void printErr(
<any type> message)
;
The printErr(<any type>)
function accepts
one argument of any data type. It takes this argument and prints
out the message
on the error output.
This function works as void printErr(<any type> arg, boolean printLocation)
with printLocation
set to false
.
Note | |
---|---|
Remember that if you are using this function in any graph
that runs on CloudConnect Server, the
|
void printErr(
<any type> message, boolean
printLocation)
;
The printErr(type, boolean)
function
accepts two arguments: the first is of any data type and the
second is boolean. It takes them and prints out the
message
and the location of the error (if the
second argument is true
).
Note | |
---|---|
Remember that if you are using this function in any graph
that runs on CloudConnect Server, the
|
void printLog(
level loglevel, <any type> message)
;
The printLog(level, <any type>)
function
accepts two arguments: the first is a log level of the
message
specified as the second argument, which
is of any data type. The first argument is one of the following:
debug
, info
,
warn
, error
,
fatal
. The log level must be specified as a
constant. It can be neither received through an edge nor set as
variable. The function takes the arguments and sends out the
message
to a logger.
Note | |
---|---|
Remember that you should use this function especially in
any graph that would run on CloudConnect
Server instead of the
|
void raiseError(
string message)
;
The raiseError(string)
function takes
one string argument and throws out error with the
message
specified as the argument.
void sleep(
long duration)
;
The function pauses the execution for specified milliseconds.