Class EnsLib.SQL.Service.ProcService

class EnsLib.SQL.Service.ProcService extends EnsLib.SQL.Service.GenericService

This Service polls a specified SQL Procedure and processes any output parameters so that they can be set as the values of the properties for some message class or inserted into a json string to be sent to the Target Configuration Items.
The Service is meant only for use with Function type Procedures. For Query type Procedures, use EnsLib.SQL.Service.GenericService.

Inventory

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	2

Summary

This is a Business Service class.

The associated Adapter class is EnsLib.SQL.InboundProcAdapter.

Properties
%AlertStartTime	%ConfigName	%ConfigQueueName
%LastActionTime	%LastHandledTime	%LastReportedError
%OutsideCreated	%PreserveSession	%ProcessInputCalled
%QuitTask	%RequestHeader	%SessionId
%SuperSession	%SuperSessionCreatedBeforeSession	%WaitForNextCallInterval
%WarnedLatest	%isShadow	Adapter
AlertGracePeriod	AlertGroups	AlertOnError
AllowTruncating	ArchiveIO	BusinessPartner
GenerateSuperSessionID	IOLogEntry	InactivityTimeout
MessageClass	OnlyWarnOnce	TargetConfigNames
ThrottleDelay

Methods
%AddToSaveSet	%ClassIsLatestVersion	%ClassName	%ConstructClone
%DispatchClassMethod	%DispatchGetModified	%DispatchGetProperty	%DispatchMethod
%DispatchSetModified	%DispatchSetMultidimProperty	%DispatchSetProperty	%Extends
%GetParameter	%IsA	%IsModified	%New
%NormalizeObject	%ObjectModified	%OnClose	%OnNew
%OriginalNamespace	%PackageName	%RemoveFromSaveSet	%SerializeObject
%SetModified	%SuperSessionSet	%ValidateObject	AdapterName
AssignOneSetting	CloseIOLogEntry	EnumerateSettingsClose	EnumerateSettingsExecute
EnumerateSettingsFetch	ForceSessionId	GenerateSuperSession	GetDeferredResponseToken
GetMsgHdrRequestKey	GetProductionSettingValue	GetProductionSettings	GetPropertyConnections
GetSettings	GetShadowInstance	NewIOLogEntry	OnError
OnGenerateSuperSession	OnGetConnections	OnInit	OnKeepalive
OnMonitor	OnProcessInput	OnProductionStart	OnProductionStop
OnTearDown	PopulateSuperSession	QueueName	SaveIOLogEntry
SendAlert	SendDeferredResponse	SendRequestAsync	SendRequestSync

Parameters

• parameter ADAPTER = "EnsLib.SQL.InboundProcAdapter";

The type of adapter used to communicate with external systems

Properties

• property Adapter as EnsLib.SQL.InboundProcAdapter;

The adapter instance

• property MessageClass as %String(MAXLEN=1000);

Message class to use in generating the request message. If this is set and the query has any output parameters, then a request message of this class will be created and the values from the output parameters and from the query results will be set into the corresponding properties of the request object. The OutputParamNames setting must be used in order to pair the output parameters with properties of the message class. If no MessageClass is specified, then the request message will take the form of an Ens.StreamContainer message containing a json string with any output parameter values as well as the query results (eg. {"ID":"1","Name":"John Smith"})


[USER] > [EnsLib] > [SQL] > [Service] > [ProcService]		Private Storage