Query Database

This AgileShape can be used to execute dynamic SQL statements and/or call database stored procedures in order to retrieve data from the database.

Properties for This AgilePart

Field Name Definition
Configure

Opens the Batch Insert Configuration dialog box, where you can configure how records are inserted into a database table.

DatabaseType

The type of database that will be used.

Timeout

Default value: 600

Specifies the maximum amount of time (in seconds) that should be allowed for the completion of the web service call for this AgileShape.

SQLType

Default value: SQL

This property determines whether this AgileShape will retrieve the data from the database using a database stored procedure, or using (one or more) dynamic SQL statements. This property can be set to the following specific values:

  • SQL - This value indicates that the data will be retrieved from the database using one or more dynamic SQL statements.
  • StoredProcedure - This value indicates that the data will be retrieved from the database using one database stored procedure. If the SqlType property is set to SQL when you click the Ellipses button, it will open a configuration dialog like the one shown below.

If the SqlType property is set to SQL when you click the Ellipses button, it will open a configuration dialog like the one shown below.



Clicking the Add button from this dialog will allow you to enter a dynamic SQL statement, and the name of the custom process attribute that the statement's return value should be stored in.



StoredProcedure Mode:

If the SqlType property is set to StoredProcedure when you click the button, it will open a configuration dialog like the one shown below.



Common AgilePart Properties

The properties of the basic AgilePart AgileShape are also included in this AgileShape. For more information, see AgilePart.