I am new at using DB2 (6 months). I am an Oracle DBA learning to use DB2.
In the test environment we are on Version 7.1. In the Production
environment we are on version 6.1. We will be moving to version 7.1 in
Production next month. I was told that stored procedures are not actually
stored in a DB2 database but that they are "binded", etc. and that the
actual stored procedure code is located in a COBOL, C, PL1, etc program. In
an Oracle database, the actual code of the procedure is stored in the
database. You don't need a COBOl, C, PL1 program to run the procedure.


I am not sure; that's the question I am asking?




-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x76596467.[Email address protected]
Sent: Thursday, August 19, 2004 3:51 PM
To: LazyDBA Discussion
Subject: Re: DB2 Version 8.2 (Stored Procedures)






Stored procedures could be stored in the database as of 7.1, do you mean
that we dont need the "C" compiler as of 8.2 ?

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Edwards Ed "
<db2udbdba-ezmlms
hield-x54553230.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]

cc
08/19/2004 03:22
PM Subject
DB2 Version 8.2 (Stored Procedures)










Is this statement true: stored procedures can be stored in the DB2 database
as of version 8.2?



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page