User Guide > Process Steps and Components > Invoker Step > Query to WebRowSet Invoker
Was this helpful?
Query to WebRowSet Invoker
The Query to WebRowSet Invoker takes a query statement, queries a database, and writes the result to one or more WebRowSet files. The component creates an empty file named EOR.xml to signal the end of query records.
Supported Actions
Action
Description
Execute
Executes the supported parameters and properties.
Supported Action Parameters
Action
Parameter
Description
Execute
SourceMessage
Name of the source message for the invoker. The body of the message must contain the query statement.
The BatchSize message property specifies the number of records to write to a WebRowSet file. If this property is not set or has a negative value, only one WebRowSet file is generated and returned in the target message. If BatchSize has a positive value, the target message contains a BatchCount property that provides the number of WebRowSet files written to TargetDirectory.
 
TargetMessage
Name of the target message for the invoker
The content of the message depends on the BatchSize property value in the source message.
Supported Action Properties
Action
Property
Description
Execute
SourceType
Source database type
SourceServer
Source server host name
SourceDatabase
Source database to query
Username
User ID to access the source database. The connection is limited to the access rights of the user ID that you use.
Password
Password to access the source database
TargetDirectory
Directory where additional WebRowSet files, if any, are written
Note:  Any property value you set in the source message overrides the invoker property value.
Last modified date: 02/01/2024