b_gilmore
Well Known Member
Re: [DB2 and Stored Procedures]
The benefit for SQL is that you can use cursors in your SP code (where you
cannot interactively like you can with PL/SQL or Transact SQL). The drawback
in my experience is it is painfully slow.
The example I created was a JDE Julian date to Date data type conversion
Stored Procedure. Granted, I was using a lot of string and cast and concat
functions to produce the result, but I gave up on it because it was so slow to
return the results set of a query when using it to return a date column vs.
the JDE Julian.
amcgreal <[email protected]> wrote:
Adminisrtator discsses the positives for using them but I can not find
anything on the JDE knowledge garden or here that is specific to DB2 and the
use of stored procedures. Anyone have some experience or insight? Thanks!Amy
McGrealSr. Programming AnalystThe Martin-Brower Company
The benefit for SQL is that you can use cursors in your SP code (where you
cannot interactively like you can with PL/SQL or Transact SQL). The drawback
in my experience is it is painfully slow.
The example I created was a JDE Julian date to Date data type conversion
Stored Procedure. Granted, I was using a lot of string and cast and concat
functions to produce the result, but I gave up on it because it was so slow to
return the results set of a query when using it to return a date column vs.
the JDE Julian.
amcgreal <[email protected]> wrote:
Adminisrtator discsses the positives for using them but I can not find
anything on the JDE knowledge garden or here that is specific to DB2 and the
use of stored procedures. Anyone have some experience or insight? Thanks!Amy
McGrealSr. Programming AnalystThe Martin-Brower Company
