AgileShapes / 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.
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:
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. |
The properties of the basic AgilePart AgileShape are also included in this AgileShape. For more information, see AgilePart.