Creating iViews Based on Stored Functions 
Use
This type of iView connects to a database application and returns results based on a selected stored procedure.
Prerequisites
· Prerequisites fulfilled as described in Creating iViews for Databases (JDBC).
· Steps 1 and 2 of the new iView wizard are completed as described in Creating iViews for Databases (JDBC).
Stored
procedures may be launched to any connector-based system. For systems other
than those for which connectors are supplied by the portal installation,
connectors must be supplied and deployed in the J2EE Engine. This is typically
performed by content developers. For more information, see 
Connector
Deployment in the Connector Framework documentation of the Portal
Developer Guide.
Procedure
Existing Function:
Screen |
Instructions |
Additional Information |
System Alias Choose System Alias |
... 1. Choose a system alias. 2. Choose Next. |
A particular system object may have a number of aliases defined for it. |
Function Finder Choose Data Retrieval Model |
3. Choose the desired function from the drop-down list of functions available for the selected system. 4. Choose Next. |
Existing function: Enables you to launch a function that has been predefined in the system from which you are retrieving data. |
Function Parameters Input Output Input/Output |
This screen displays input, output, or input/output parameters that are valid for the function module you selected in the previous step. 5. Enter values where necessary. (Mandatory fields are indicated by an asterisk.) 6. Choose Next. |
After the iView is created, you may modify the property values as needed. You may want to determine which parameters have fixed values, and which are personalizable by end user in run time. |
Summary Details |
7. Review the options defined for the new iView and choose Finish. To make changes, choose Back until you return to the appropriate screen. |
|
Next Step |
8. Choose your next step and click OK. · You have the option of opening the object Property Editor at the end of the wizard. The iView may need editing before it can be used as intended, for example enabling Drag&Relate. If you want to define the new iView as a template, by setting the Object is a Template property to Yes. · You have the option of restarting the wizard to create a new iView. |
|
Result
A JDBC Stored Procedure iView based on JDBC is created in the selected folder.
You may preview the
iView in several ways; see Previewing an Object
(iViews and Pages) and Previewing an Object
from an Editor (iViews and Pages). If needed, you may edit the default
properties in the Property
Editor.
When you create an iView based on the default JDBC Stored Procedure iView template, the new iView is linked to the iView template through a delta link relationship. Any modifications you make to generic properties in the iView template will be updated in the new iView.