Application Integration
- Application Integration
- All Products
execSQL Input Element
| Description
|
---|---|
sqlStatement
| Element containing the required
<statement> and optional attributes
|
includeMetadata
| Returns a row of metadata about the query columns prior to the actual return data (the default is false). Meta data includes data type and display size.
|
maxRows
| Maximum number of result rows to be returned. The default is 0 or unlimited.
|
maxWaitSeconds
| Maximum time in seconds to wait for processing the result. This option does not consider the time taken to run the query. Use this option to interrupt long processing of a large query result. The default is 0 or unlimited.
|
columnCase
| Specifies the case formatting of the columns in the result set (the default is
unchanged from server). Schema enumerations defined for this element include lowercase, uppercase, and unchanged.
|
statementId
| Specified as part of request to help identify results (the default is to auto generate an Id that results in an Id such as statement-1, statement-2)
|
statement
| Required. SQL statement to execute.
|
parameter
| Identifies the data to be inserted, updated or deleted from the data source. Parameter values are listed in order within a
<parameterBatch>
element associated with a statement.
|
sqlType
| Parameter attribute. Types include string (default), byte, short, int, long, float, double, date, binary, or clob.
|
attachmentId
| Parameter attribute. Specified as part of request to help identify results attachments, if any.
|
hasResultSet
| Indicates that a stored procedures returns data. Only use this parameter if this is true.
|
<das:dataAccessRequest xmlns:das="http://schemas.active-endpoints.com/data-access/2010/04/data-access.xsd"> <das:sqlStatement includeMetadata="true" maxRows="100" maxWaitSeconds="120" columnCase="lowercase"> <das:statement>SELECT EngineId, Name, State FROM AeEngine ORDER BY 1</das:statement> </das:sqlStatement> </das:dataAccessRequest>
<dataAccessResponse xmlns="http://schemas.active-endpoints.com/data-access/2010/04/data-access.xsd" statementId="statement-1" > <metadata> <engineid dataType="INT UNSIGNED" displaySize="10" xmlns=""/> <name dataType="VARCHAR" displaySize="255" xmlns=""/> <state dataType="TINYINT" displaySize="4" xmlns=""/> </metadata> <row> <engineid xmlns="">1</engineid> <name xmlns="">machine1</name> <state xmlns="">1</state> </row> </dataAccessResponse>
<das:multiDataAccessRequest xmlns:das="http://schemas.active-endpoints.com/data-access/2010/04/data-access.xsd"> <das:sqlStatement includeMetadata="false" statementId="num-processes"> <das:statement>SELECT COUNT(*) AS ProcessCount FROM AeProcess</das:statement> </das:sqlStatement> <das:sqlStatement includeMetadata="false" statementId="num-plans" sqlcode='0' sqlstate='0'> <das:statement>SELECT COUNT(*) AS PlanCount FROM AePlan</das:statement> </das:sqlStatement> <das:sqlStatement includeMetadata="false" statementId="metainfo"> <das:statement>SELECT * FROM AeMetaInfo</das:statement> </das:sqlStatement> </das:multiDataAccessRequest>
<multiDataAccessResponse xmlns="http://schemas.active-endpoints.com/data-access/2010/04/data-access.xsd"> <result statementId="num-processes"> <row> <ProcessCount xmlns="">3</ProcessCount> </row> </result> <result statementId="num-plans"> <row> <PlanCount xmlns="">18</PlanCount> </row> </result> <result statementId="metainfo"> <row> <PropertyName xmlns="">DatabaseType</PropertyName> <PropertyValue xmlns="">mysql</PropertyValue> </row> <row> <PropertyName xmlns="">SiteId</PropertyName> <PropertyValue xmlns="">0</PropertyValue> </row> <row> <PropertyName xmlns="">SiteName</PropertyName> <PropertyValue xmlns="">mySite1</PropertyValue> </row> <row> <PropertyName xmlns="">Version</PropertyName> <PropertyValue xmlns="">1.2.3 ActiveVOS Enterprise</PropertyValue> </row> </result> </multiDataAccessResponse>