String fenced, in Class DB2Routine

Documentation
From the DB2 SQL Reference for Cross-Platform Development v1.1

Specifies that the external function or procedure runs in an environment that is isolated from
the database manager environment.


From the v8.1 UDB documentation for external UDFs and stored procedures:

This clause specifies whether the stored procedure is considered "safe" to
run in the database manager operating environment's process or address
space (NOT FENCED), or not (FENCED).
If a stored procedure is registered as FENCED, the database manager
protects its internal resources (for example, data buffers) from access by
the procedure. All procedures have the option of running as FENCED or
NOT FENCED. In general, a procedure running as FENCED will not
perform as well as a similar one running as NOT FENCED.

CAUTION:
Use of NOT FENCED for procedures that have not been adequately
checked out can compromise the integrity of DB2. DB2 takes some
precautions against many of the common types of inadvertent failures
that could occur, but cannot guarantee complete integrity when NOT
FENCED stored procedures are used.

Either SYSADM authority, DBADM authority, or a special authority
(CREATE_NOT_FENCED) is required to register a stored procedure as
NOT FENCED. Only FENCED can be specified for a stored procedure
with LANGUAGE OLE or NOT THREADSAFE.

To create a not-fenced stored procedure, the privileges held by the
authorization ID of the statement must also include at least one of the
following:
- CREATE_NOT_FENCED_ROUTINE authority on the database
- SYSADM or DBADM authority.

To create a fenced stored procedure, no additional authorities or privileges are
required. If the authorization ID has insufficient authority to perform the operation, an
error (SQLSTATE 42502) is raised.

As of Sept 2003, there isn't a Fenced attribute for 390. There is one
supported for as400 is done so for compatibility purposes.


Export ControlPublicAccessContainmentUnspecified
StaticNoDerivedNo


Property Settings

Data Modeler
dmItemFalseDMName 
Ordinal0IsIdentityFalse
IsUniqueFalseNullsAllowedFalse
Length0Scale0
ColumnTypeNativeForBitDataFalse
DefaultValueType DefaultValue 
SourceId SourceType 
OIDFalse