Starting with version 8.2, the need for a c compiler for sql procedures is
no longer required.

As for earlier versions 8.1 and earlier, the actual source of the stored
procedures is stored within the database; however, to compile them you need
a stored procedures. You can use the get routine and put routine commands to
move stored procedures from one server to another, thereby not necessarily
needing a c compiler on the target server (moving from development to qa,
for example, you need a compiler on development, but not on qa). In versions
8.1 and earlier, the create stored procedure command actually converted your
sql procedure to c, and compiled it and bound the exectuable into a package.
They rewrote the create procedure so that it no longer converts it to C, but
some internal representation that UDB can execute.



-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x50867279.[Email address protected]
Sent: Thursday, August 19, 2004 4:00 PM
To: LazyDBA Discussion
Subject: RE: DB2 Version 8.2 (Stored Procedures)


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


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

*************************************************************
This message, including any attachments, may contain
confidential information intended for a specific individual
and purpose, and may be protected by law. If you are not
the intended recipient, please notify the sender by e-mail
or telephone immediately, and then immediately delete this
message. Any disclosure, copying or distribution of this
message, or the taking of any action based on it, by any
unintended recipient is strictly prohibited.

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