Importing stored procedures
When you import your metadata from a relational data source, you can also import stored procedures. The Framework Manager only supports the import of user-defined stored procedures. When you have imported your stored procedure, you can treat it as if it were a database table and can create joins to other objects.
You can import your stored procedures as part of the initial import of metadata or at a later time. After importing your stored procedure into the Framework Manager, the procedure must first be run in order to get a description of the result set that the procedure returns.
There are certain rules that imported stored procedures must follow for them to work with the Framework Manager:
- The stored procedure must ...
Get IBM Cognos 10 Framework Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
