You use the following data query actions to load an XML document from the relevant SAP Manufacturing Integration and Intelligence (SAP MII) query type:
Tag Query
SQL Query
XML Query
Alarm Query
OLAP Query
Aggregate Query
MDO Query
PCo Query
Note
When you run a query, the system asks if you want to create a sample XML document. If you are running an update, insert, or delete query, you may not want to create a sample.
All query objects have similar configurations. You select a query template and set parameter name-value pairs. The default SAP MII server is localhost.
Common properties for the data query actions are listed in the following table:
Property |
Data Type |
Access |
Use |
QueryTemplate |
String |
In and out |
Defines the query template that is used to load the XML content. |
Timeout |
Integer |
In and out |
Defines the amount of time in seconds that the transaction waits for a response from the query before it times out. |
Success |
Boolean |
Out |
Evaluates to true if the query executes without a fatal error. If false, the fatal error message can be accessed with the following XPATH: [ActionName].Results{/Rowsets/FatalError}. |
Results |
XML |
Out |
Stores the XML results from the query. |
QueryStartDate |
DateTime |
In and out |
At execution time, it is converted to the date and time format that is specified in the query and is written to the query's StartDate parameter. |
QueryEndDate |
DateTime |
In and out |
At execution time, it is converted to the date and time format that is specified in the query and is written to the query's EndDateparameter. |
In addition to the common properties, each query action has its own properties.