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


Chapter 2 Designing an OIG Application : Using Data Access Parameters

Using Data Access Parameters
When accessing data through generic data access rules and XML generation, you can supply data access parameters. These take two forms: data parameter values and data key values. A data parameter value specifies the criteria that enables Object Integration Gateway to determine the parameter value required to access a parameterized data table. A data key value specifies the selection criteria that OIG uses to select data from the data table.
For information about the syntax required for data parameter values and data key values, refer to Appendix B, Understanding the Data Access Parameter Syntax.
Data Access Parameters Can Be Dynamic
Data access parameters do not have to be static, but can be dynamic, either totally or partially. Specifying data access parameters as static values is a valid, but limiting, approach. The only requirement is that the resultant values make up a valid data access specification.
For example, the specification to access all rows of data from the table MYTABLE, where the field VALID is set to Y and the field VALUE is greater than a given integer, could be as follows:
Key Value = "VALID = 'Y' AND VALUE > 123"
In this example we could have any part of the predicate string as dynamic. A good example would be that we wanted to pass the value for the field VALUE from the web application as a session data value or as a name-value pair argument called SELECTEDVALUE. In this case, the key value for the object would be:
Key Value = "VALID = 'Y' AND VALUE > {SELECTEDVALUE}"

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