Class DB2Procedure {Analysis} derived from: ProcedureDB2Routine

Documentation
SQL Reference for Cross-Platform Development - v1.1
http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html

Procedures (Chapter 1. Concepts 9)

A procedure (sometimes called a stored procedure) is a routine that can be called to perform operations that can include both host language statements and SQL statements.

Procedures are classified as either SQL procedures or external procedures. SQL procedures contain only SQL statements. External procedures reference a host language program which may or may not contain SQL statements. A procedure is created with the CREATE PROCEDURE statement. For more information about creating procedures, see "CREATE PROCEDURE" on page 366.

Procedures in SQL provide the same benefits as procedures in a host language. That is, a common piece of code need only be written and maintained once and can be called from several programs. Host languages can easily call procedures that exist on the local system. SQL can also easily call a procedure that exists on a remote system. In fact, the major benefit of procedures in SQL is that they can be used to enhance the performance characteristics of distributed applications.

Assume several SQL statements must be executed at a remote system. There are two ways this can be done. Without procedures, when the first SQL statement is executed, the application requester will send a request to an application server to perform the operation. It then waits for a reply that indicates whether the statement executed successfully or not and optionally returns results. When the second and each subsequent SQL statement is executed, the application requester will send another request and wait for another reply. If the same SQL statements are stored in a procedure at an application server, a CALL statement can be executed that references the remote procedure. When the CALL statement is executed, the application requester will send a single request to the current server to call the procedure. It then waits for a single reply that indicates whether the CALL statement executed successfully or not and optionally returns results.


Parent PackageDB2ModelAbstractNo
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Operations
NameSignatureClass
addEAnnotationEAnnotation addEAnnotation (String source)SQLObject
addEAnnotationDetailvoid addEAnnotationDetail (EAnnotation eAnnotation, String key, String value)SQLObject
getEAnnotationDetailString getEAnnotationDetail (EAnnotation eAnnotation, String key)SQLObject
setAnnotationDetailvoid setAnnotationDetail (EAnnotation eAnnotation, String key, String value)SQLObject
removeEAnnotationDetailvoid removeEAnnotationDetail (EAnnotation eAnnotation, String key)SQLObject
getEAnnotationEAnnotation getEAnnotation (String source)SQLObject
getEAnnotationEAnnotation getEAnnotation (String source)EModelElement
eClassEClass eClass ()EObject
eIsProxyboolean eIsProxy ()EObject
eResourceEResource eResource ()EObject
eContainerEObject eContainer ()EObject
eContainingFeatureEStructuralFeature eContainingFeature ()EObject
eContainmentFeatureEReference eContainmentFeature ()EObject
eContentsEEList eContents ()EObject
eAllContentsETreeIterator eAllContents ()EObject
eCrossReferencesEEList eCrossReferences ()EObject
eGetEJavaObject eGet (EStructuralFeature feature)EObject
eGetEJavaObject eGet (EStructuralFeature feature, boolean resolve)EObject
eSet eSet (EStructuralFeature feature, EJavaObject newValue)EObject
eIsSetboolean eIsSet (EStructuralFeature feature)EObject
eUnset eUnset (EStructuralFeature feature)EObject


Attributes
NameClassTypeInitial Value
modelResultSetsDB2Procedurebooleanfalse
nullInputDB2Procedureboolean 
versionDB2ProcedureString 
maxResultSetsProcedureint 
oldSavePointProcedureboolean 
specificNameRoutineString 
languageRoutineString 
parameterStyleRoutineString 
deterministicRoutineboolean 
sqlDataAccessRoutineDataAccess 
creationTSRoutineString 
lastAlteredTSRoutineString 
authorizationIDRoutineString 
securityRoutineString 
externalNameRoutineString 
descriptionSQLObjectString 
labelSQLObjectString 
nameENamedElementString 
fencedDB2RoutineString 
threadsafeDB2RoutineString 
dbInfoDB2Routineboolean 
implicitSchemaDB2Routineboolean 
federatedDB2Routineboolean 
parmCcsidDB2RoutineString 
specialRegisterDB2RoutineString 
changeStateDB2Routineint0
debugIdDB2RoutineString 
programTypeDB2RoutineString 
origSchemaNameDB2RoutineString 
origParmSigDB2RoutineString 


Associations
NameMy RoleMy ClassOther RoleOther Element
--Not Named----Not Named--DB2ProcedurereturnIntegerDataType
--Not Named--procedureDB2ProcedurejavaOptionsDB2JavaOptions
--Not Named----Not Named--DB2ProceduredeployDB2ProcedureDeploy
--Not Named----Not Named--ProcedureresultSetRoutineResultTable
--Not Named--remoteProcedureProcedure--Not Named--FederatedProcedure
--Not Named--routineRoutineparametersParameter
--Not Named--routineRoutinesourceSource
--Not Named--routinesRoutineschemaSchema
--Not Named--orderingRoutineRoutine--Not Named--UserDefinedTypeOrdering
--Not Named----Not Named--SQLObjectcommentsComment
=--Not Named--SQLObjectdependenciesDependency
--Not Named--objectSQLObjectprivilegesPrivilege
--Not Named--actionObjectsSQLObject--Not Named--Privilege
--Not Named--eModelElementEModelElementeAnnotationsEAnnotation
--Not Named--contentsEObject--Not Named--EAnnotation
--Not Named--referencesEObject--Not Named--EAnnotation
--Not Named--targetEndEObject--Not Named--Dependency
--Not Named----Not Named--DB2RoutineextendedOptionsDB2ExtendedOptions
--Not Named----Not Named--DB2RoutineroutineExtensionsDB2RoutineExtension
--Not Named--accessPlansDB2AccessPlan--Not Named--DB2Schema


Dependencies
NameClassSupplier
--Not Named--DB2ProcedureDB2JavaOptions


Generalization Relationships
NameClassSupplier
--Not Named--DB2ProcedureProcedure
--Not Named--DB2ProcedureDB2Routine
--Not Named--ProcedureRoutine
--Not Named--RoutineSQLObject
--Not Named--SQLObjectENamedElement
--Not Named--ENamedElementEModelElement
--Not Named--EModelElementEObject
--Not Named--DB2RoutineRoutine
--Not Named--DB2RoutineDB2AccessPlan
--Not Named--DB2AccessPlanSQLObject



Property Settings

Data Modeler
dmItemFalseDMName 
IsTableFalseIsViewFalse
IsDomainFalseIsSPPackageFalse
Synonymns TableSpaceID 
SourceId SourceType 
CorrelationName SelectClause 
IsUpdateableTrueCheckOptionNone
IsSnapShotFalseIsDistinctFalse
PersistToServer IsPackageFalse