Idea Details

Allow action diagrams to be implemented as stored procedures - F32432

Last activity 10-19-2017 12:08 PM
Anon Anon's profile image
06-24-2014 07:21 PM

Through generation and packaging, allow a common action diagram to be implemented as a stored procedure for the target database.


Note that this idea came from the members of the European user groups at the user group meetings held in March, 2014.


10-19-2017 12:07 PM

Moving this to "Currently Planned", as we intend to develop this functionality. Once we have an actionable plan, I will share details here for community comment and review.


This is a fairly large undertaking, so it is not on schedule for any near-term delivery.




Rob Thompson

Product Owner, CA Gen 

11-01-2015 06:34 PM

John, For additional benefits, on z/OS (for DB2) I believe that there would be cost savings achieved through the offload of GPU processing to the specialist processors. Tim

11-01-2015 10:42 AM

I believe there is value, beyond performance, to allowing an application layer around the data.  You might have sensitive data on certain rows or columns that you want to protect.  It may be a very complex data structure that you want to provide a simple interface to allow access to.  And, for maintenance actions, you may want business rules to be enforced.  This is just another way to expose your CA Gen application code for reuse.


Just last year, we had web/BPM developers asking for stored procedures to access and update the DB2 tables within our CA Gen written application.  We compromised with them on stored procedures for inquiry access and using an API (written in CA Gen) with .Net proxy for maintenance.  The stored procedure is a common connector for some of these types of applications and they would have preferred that.

10-29-2015 04:39 PM

I understand that supporting action diagrams as stored procedures might deliver performance benefits for ODBC/JDBC (which includes SQL Server) targets but I'm not so sure for embedded SQL targets (DB2 and Oracle).  Does anyone have any evidence of performance improvements using stored procedures when targeting DB2 and/or Oracle?   And does anyone have any evidence of other benefits of using stored procedures?

09-05-2015 09:37 PM

CA Gen applications are typically highly I/O intensive and being able to deploy stored procs from CA Gen would potentially deliver significant performance benefits - on all supported DB platforms.