Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Using the OIG COM Component : Passing Data to the Object Integration Gateway COM Component

Passing Data to the Object Integration Gateway COM Component
Overview
In the following method descriptions, the required format for parameters is explained and the parameter syntax for the COM component methods is described.
Strings
A simple string value:
Transaction = "DEMOTX"
String Arrays
The COM object can accept string arrays in two formats. The first is an array of arrays, and the second is a two-dimensional array. The first format is an easy-to-use format that does not require any variable to be declared. The second format requires that a variable be defined, but the advantage of this is that the defined variable and its values can be reused within the application.
Format 1: Array of Arrays (Object Integration Gateway 1.x Compatible)
Example:
MySession.RunTrans "DEMOTX", Array(Array("NAME", "VALUE"))
Format 2: Two-Dimensional Arrays
Array(x, y) = "stringvalue"
where x is the vertical dimension of the array (indexed from zero) and y is the horizontal dimension of the array (indexed from zero).
Dim MyArgs(0,1) As String
MyArgs(0,0) = "NAME"
MyArgs(0,1) = "VALUE"
MySession.RunTrans "DEMOTX", MyArgs
Dim MyArgs(0,1)
MyArgs(0,0) = "NAME"
MyArgs(0,1) = "VALUE"
MySession.RunTrans "DEMOTX", MyArgs
Recordsets
An ADO 2.5 or later Recordset object can be used both as input to and a result from Object Integration Gateway methods. In the case of the result recordset, this is a disconnected recordset. This means that it is not actively connected to the source database, so any updates made to the recordset do not get reflected in the source database, only in the recordset. However, this result recordset can be amended and used to pass data to another method call.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved