EnsLib.SQL.InboundProcAdapter
class EnsLib.SQL.InboundProcAdapter extends EnsLib.SQL.InboundAdapter
SQL database-polling client adapter. Repeatedly executes a sql procedure against a remote database via an ODBC- or JDBC- defined DSN (Data Source Name) and processes each resulting row.Property Inventory
Method Inventory
Parameters
parameter DOMAIN = ENSEMBLE;
parameter SETTINGS = -Query,Procedure:Data,IO:Data,OutputParamNames:Data,-DoNotInterruptResultSet,EscapedCallRequiresBracing:Data;
Inherited description: These are the production settings for this object
Properties
property EscapedCallRequiresBracing as %Boolean [ InitialExpression = 1 ];
JDBC escape call syntax requires the statement to be wrapped in {}
Property methods: EscapedCallRequiresBracingDisplayToLogical(), EscapedCallRequiresBracingGet(), EscapedCallRequiresBracingIsValid(), EscapedCallRequiresBracingLogicalToDisplay(), EscapedCallRequiresBracingNormalize(), EscapedCallRequiresBracingSet()
property IO as %String;
A text string in which each character corresponds to one of the query parameters. The character 'i' means the
corresponding parameter is an Input parameter. The character 'o' means it is an Output parameter, and 'b' means it is Both an Input
and an Output parameter. If the procedure is a function which has a return value, an 'o' should be added in front to account for the return value.
Property methods: IODisplayToLogical(), IOGet(), IOIsValid(), IOLogicalToDisplay(), IOLogicalToOdbc(), IONormalize(), IOSet()
property OutputParamNames as %String);
A comma-separated list of property names corresponding to any output parameters of the procedure.
If the procedure is a function, each parameter with an IO type of either 'o' or 'b' should have a name specified.
Property methods: OutputParamNamesDisplayToLogical(), OutputParamNamesGet(), OutputParamNamesIsValid(), OutputParamNamesLogicalToDisplay(), OutputParamNamesLogicalToOdbc(), OutputParamNamesNormalize(), OutputParamNamesSet()
property Procedure as %String (MAXLEN = 1000);
The name of the procedure to be called by this Service. This should include any ? characters used to indicate parameters of the procedure, but
should not include any SQL commands (eg. Select) with the exception that the CALL command must be included if ?= is used.
Specifying preceding ?=CALL is optional if the procedure provides a RETURN (Note the Input/Output Setting must include the leading o for the return.)
For example the following are valid:
schema.proc(?,?) with Input/Output of oii - this will result in ? = CALL schema.proc(?,?)
schema.proc(?,?) with Input/Output of ii - this will result in CALL schema.proc(?,?)
? = CALL schema.proc(?,?) with Input/Output of oii - this will result in ? = CALL schema.proc(?,?)
CALL schema.proc(?,?) with Input/Output of ii - this will result in CALL schema.proc(?,?)
Specifying preceding ?=CALL is optional if the procedure provides a RETURN (Note the Input/Output Setting must include the leading o for the return.)
For example the following are valid:
schema.proc(?,?) with Input/Output of oii - this will result in ? = CALL schema.proc(?,?)
schema.proc(?,?) with Input/Output of ii - this will result in CALL schema.proc(?,?)
? = CALL schema.proc(?,?) with Input/Output of oii - this will result in ? = CALL schema.proc(?,?)
CALL schema.proc(?,?) with Input/Output of ii - this will result in CALL schema.proc(?,?)
Property methods: ProcedureDisplayToLogical(), ProcedureGet(), ProcedureIsValid(), ProcedureLogicalToDisplay(), ProcedureLogicalToOdbc(), ProcedureNormalize(), ProcedureSet()
Methods
method OnInit() as %Status
Inherited description: This user callback method is called just after %OnNew()
method OnTask() as %Status
Copied from EnsLib.SQL.InboundAdapter, except adjusted to use ExecuteProcedureParmArray and make use of IO and returned parameters
Inherited Members
Inherited Properties
- %ClientIOAddr
- %IOAddr
- %JGConnectTimeout
- %JavaGateway
- %WarnedLatest
- %logConnections
- BusinessHost
- CallInterval
- ConnectAttrs
- ConnectTimeout
- Connected
- ConnectionAttributes
- Credentials
- DSN
- DeleteQuery
- DoNotInterruptResultSet
- ExtraJGClasspaths
- IsUnicodeDLL
- JDBCClasspath
- JDBCDriver
- JGClientConnectSpec
- JGClientEnsClassname
- JGService
- KeepaliveInterval
- KeyFieldName
- MaxVarCharLengthAsString
- ParamSQLTypes
- Parameters
- Query
- RegistryID
- StatementAttrs
- StayConnected
- attrIDs
- updatecount
Inherited Methods
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OriginalNamespace()
- %PackageName()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- AssignOneSetting()
- BindOutputParameter()
- ClearAllAppData()
- ClearRuntimeAppData()
- ClearStaticAppData()
- Commit()
- Connect()
- ConnectAttrsGet()
- ConnectAttrsSet()
- ConnectJ()
- ConnectedSet()
- ConvertSQLTypeToInt()
- CredentialsSet()
- DSNSet()
- DescribeColumns()
- DescribeParameters()
- Disconnect()
- DisconnectJ()
- DropResultSet()
- DropStatement()
- EnumerateSettingsClose()
- EnumerateSettingsExecute()
- EnumerateSettingsFetch()
- ExecuteProcedure()
- ExecuteProcedureParmArray()
- ExecuteQuery()
- ExecuteQueryParmArray()
- ExecuteUpdate()
- ExecuteUpdateParmArray()
- Fetch()
- FetchAhead()
- GetArgLOBData()
- GetData()
- GetDataW()
- GetErrorList()
- GetLastSQLCode()
- GetParameter()
- GetPersistentValue()
- GetSettings()
- InitializeLastKeyValue()
- InitializePersistentValue()
- JDBCClasspathSet()
- MoreResults()
- OnKeepalive()
- OnTearDown()
- Rollback()
- RowCount()
- SetAutoCommit()
- SetConnectAttr()
- SetConnectOption()
- SetPersistentValue()
- SetStmtOption()
- TestConnection()
- TestConnectionJ()
- Transact()
- addErrorList()
- getConfigObj()
- getProcedureParameters()
- initAdapterJG()
- initJG()
- isNetErr()
- putLOBStream()
- putLOBStreams()