Mapping Data Between the Process and the Database
Each input and output parameter defined in the SQL query or stored procedure must be mapped to a corresponding data field or parameter in the process.
Depending on the type of the database parameter, the process data field or parameter can be:
- a simple data field or parameter
- an existing business object model object
- (for values returned to the process from the database) a new business object model object. See
Automatically Creating a Business Object Model to Store Returned Data.
Mapping Data Parameters for each parameter required by the SQL query or stored procedure
- Mapping Data Parameters
You must map parameters for each parameter required by the SQL query or stored procedure - Mapping an Externally Referenced Class Attribute to a Database Parameter
A process formal parameter, or a package-level or process-level data field, cannot be mapped to a database parameter if the parameter or data field is defined as an external reference to an attribute of a class defined in a business object model (that is, as structured data). - Automatically Creating a Business Object Model to Store Returned Data
You can automatically create a business object model to store data returned by the SQL query or stored procedure. - Mapping the Result Set
TIBCO Business Studio automatically populates the Database tab with the return parameters from the stored procedure.
Copyright © Cloud Software Group, Inc. All rights reserved.