Fred,
actually, the SQL procedures, being "internal", are not fenced. For external procedures, you still have the option. If you look in the V8 SQL Reference Vol. 2, there are two flavors of the create procedure statement, one for external and one for SQL. And the external one still contains the fenced / not fenced option. And for a comparison, if you look in the V7 SQL Reference, the fenced / not fenced option of the create procedure command is listed as an "external procedure option".
/T
Tomas Hallin
Database Administration
Robert Half International
Pleasanton, CA
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 2:05 PM
To: [EMAIL PROTECTED]
Subject: [DB2EUG] DB2 V8 Fenced SQL Procedures
Hello,
I noticed that the CREATE PROCEDURE command doesn't seem to offer the
option to create fenced SQL procedures, and that procedures I've recently
created in V8 (as opposed to migrating from V7) are not fenced anymore. Is
this right?
Fred
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
