Skip to Content

Memory() mvSQL runtime function in Jitterbit App Builder

Summary

Returns value of column from Shared() function if exists, otherwise from the Caller() function.

Syntax

Memory(<name> [, <datatype> ])

Parameters

name

A string representing the requested column by name.

datatype

Data type, string is default, optional. Supported datatypes:

  • String (default)
  • Numeric
  • UUID
  • Boolean
  • DateTime

Note

The datatype parameter is optional by default. If the Require Function Type Parameter option is enabled in the data source's Advanced Settings, the parameter becomes required. This is useful when deploying applications across different database types.

Returns

A value of datatype datatype, or NULL if name references an unavailable column.

Examples

Memory('AppID', UUID) returns B58736D1-B42C-450E-B017-ACE3C99B8F65.