DML functions: Miscellaneous

generateUniqueId

isAbsent

isNull

isNullOrAbsent

isObjectAvailableOnServer

replaceIfAbsent

replaceIfNull

replaceIfNullOrAbsent

The following Miscellaneous functions are available:

generateUniqueId

generateUniqueId Comment

Description

generateUniqueId generates a unique identifier with the specified type.

Syntax

generateUniqueId (type)

Return

String

Parameter

type (String constant):

"ALPHA" - The generated identifier is alphanumeric.
"NUMERIC" - The generated identifier is numeric.

Example

generateUniqueId("ALPHA") returns 4288945603574814573189143

isAbsent

isAbsent Comment

Description

isAbsent checks an expression for the value absent.

Syntax

isAbsent(expression)

Return

Boolean

If the value of the expression is:

  • absent, isAbsent returns true.
  • not absent, isAbsent returns false.

Parameter

expression
Enter
an expression from any data class.

Example

In the following example, isAbsent checks the returnColumn expression for the value absent. If returnColumn does not find the node it is looking for, isAbsent returns a default value. If returnColumn finds the node, the Function returns that node.

if isAbsent(returncolumn(CustomerType, CustomerId))

then default_CustomerType

else returnColumn(CustomerType, CustomerId)

isNull

isNull Comment

Description

isNull checks an expression for the value null.

Syntax

isNull(expression)

Return

Boolean

If the value of the expression is:

  • null, isNull returns true
  • not null, isNull returns false

Parameter

expression
Enter an expression from any data class.

Example

The following example tests an input node for the value null. If the returned value is null, then the expression is replaced by a default value.

ifisNull(\CustomerTransaction\CustomerType)

then default_CustomerType

elseCustomerType

isNullOrAbsent

isNullOrAbsent Comment

Description

isNullOrAbsent checks an expression for the values null or absent.

Syntax

isNullOrAbsent(expression)

Return

Boolean

If the value of the expression is:

  • null or absent, isNullOrAbsent returns true
  • not null or absent, isNullOrAbsent returns false

Parameter

expression
Enter an expression from any data class

Example

The following example tests an input node for the value null or absent. If the returned value is null or absent, then the expression is replaced by a default value.

if isNullOrAbsent(\CustomerTransaction\CustomerType)

then default_CustomerType

else CustomerType

isObjectAvailableOnServer

isObjectAvailableOnServer Comment

Description

isObjectAvailableOnServer enables you determine if a specific object (specified by type and name) is deployed on the Map Engine Server.

For use in decision path, Map, Validation Rule, Trigger and for the initialization of Variables.

Use this function, for example, to determine if a target Flow is deployed on the Mapping Services Server before executing it through Dynamic Flow loading.

Syntax

isObjectAvailableOnServer(object type,object name>)

Return

Boolean

Returns true if the object is found on the server or false if the object is not found.

Parameters

object type (string)

Enter the type of the object to perform a search. Possible values are:

  • BusinessDocument
  • Function
  • DML Block
  • Table
  • Variable
  • Flow

object qualified name (string)

Enter the name of the object to perform a search. Enter a name in any of the following formats:

  • Qualified name: Entity.Folder.Name
  • Partial name: Folder.Name
  • Partial name: Name

Example

isObjectAvailableOnServer("Flow", "MyTransformationStage")

Returns trueif the Flow named MyTranformationStage is located on the server, false if it is not found.

replaceIfAbsent

replaceIfAbsent Comment

Description

replaceIfAbsent checks an expression for the value absent. If the value of the expression:

  • is absent, replaceIfAbsent replaces the expression with another one
  • is not absent, replaceIfAbsent returns the expression unchanged

Syntax

replaceIfAbsent(expression, replace_expression)

Return

replaceIfAbsent returns the same data class as the expression that it checks. It can check expressions of any data class.

Parameters

expression
Enter a
n expression from any data class

replace_expression
Enter a
n expression from the same data class as expression

Example

The following example tests an input node for the value absent. If the returned value is absent, then the expression is replaced by a default value.

replaceIfAbsent(CustomerType, default_CustomerType)

replaceIfNull

replaceIfNull Comment

Description

replaceIfNull checks an expression for the value null. If the value of the expression:

  • is null, replaceIfNull replaces the expression with another one.
  • is not null, replaceIfNull returns the expression unchanged.

Syntax

replaceIfNull(expression, replace_expression)

Return

replaceIfNull returns the same data class as the expression that it checks. It can check expressions of any data class.

Parameters

expression
Enter
an expression from any data class

replace_expression
Enter an expression from the same data class as expression

Example

The following example tests an input node for the value null. If the returned value is null, then the expression is replaced by a default value.

replaceIfNull(CustomerType, default_CustomerType)

replaceIfNullOrAbsent

replaceIfNullOrAbsent Comment

Description

replaceIfNullOrAbsent checks an expression for the values null and absent. If the value of the expression:

  • is null or absent, replaceIfNullOrAbsent replaces the expression with another one.
  • is not null or absent,replaceIfNullOrAbsent returns the expression unchanged.

Syntax

replaceIfNullOrAbsent(expression, replace_expression)

Return

replaceIfNullOrAbsent returns the same data class as the expression that it checks. It can check expressions of any data class.

Parameters

expression
Enter an expression from any data class

replace_expression
Enter an expression from the same data class as expression

Example

The following example tests an input node for the value null or absent. If the returned value is null or absent, then the expression is replaced by a default value.

replaceIfNullOrAbsent(CustomerType, default_CustomerType)

Related Links