Unlock the Power of IIB Outputroot.json.data for SQL Passthru

I'm trying to make something reusable because I'll have a number of stored proc to JSON methods to implement. I guess it depends on the technical requirements. You can do this by using the ASBITSTREAM function on the message tree where you built your first JSON message and then using CAST to convert the resulting BLOB ... Creating JSON Array and Assign the values. CREATE FIELD OutputRoot.JSON.Data.payments IDENTITY(JSON.Array);. SET OutputRoot.JSON.Data.payments ... When you are working with SQL statements that require literal or data values, use host variables, which map a column value to a variable. I have prepared a guide that will help and teach you, how to pass both XML and JSON data models between ESQL and Java. You can create JSON message data that contains JSON objects, JSON arrays, or both, by creating elements in the logical message tree. IBM Integration Bus V9 Best practices. Version 9 Release 0. Reducing memory usage with parsers and. message trees. IBM. By: Craig Briscoe David Crighton Object)Data; SET OutputRoot.JSON.Data = InputLocalEnvironment.Backup.Data; ... Create a JSON Array in IBM Integration Bus. at October 06, 2017. However, when I promote the Environment variable to OutputRoot.JSON.Data by doing the following: Code: SET OutputRoot.JSON.Data = Environment. ESQL PASSTHRU statement. The following techniques can ... When you are working with SQL statements that require literal or data ...