-
1. Re: How do I import DB2 stored procedure and user functions into a Teiid model schema?
rareddy Jul 13, 2011 10:53 AM (in response to bluesgtrst)Yes, Teiid allows import of stored procedures. There should be check box.
No, functions are not imported currently. However, there are currently work arounds to define souce specific functions. Take a look at User Defined Functions, with push down option. Auto import is on the road map.
Ramesh..
-
3. Re: How do I import DB2 stored procedure and user functions into a Teiid model schema?
bluesgtrst Jul 13, 2011 12:02 PM (in response to rareddy)I may be able wrap the user-defined function in a stored procedure. Where can I find the "check box"? I currently cannot import db2 stored procedures either.
Thanks, Jeff
-
4. Re: How do I import DB2 stored procedure and user functions into a Teiid model schema?
blafond Jul 13, 2011 12:35 PM (in response to bluesgtrst)Second page of the JDBC Importer wizard (Select Database Metadata page). Last option on left side : "Procedures"
-
6. Re: How do I import DB2 stored procedure and user functions into a Teiid model schema?
bluesgtrst Jul 14, 2011 10:06 AM (in response to blafond)OK, so now I have an xmi file defining the metadata for my db2 stored procedure. How do I implement this file under jboss and how do I go about mapping a Teiid SQL query to the input/output parameters of the stored procedure?