Datasource Name | Select the datasource for the database you want to work with. If there is no datasource for this database, contact your MashZone NextGen administrator to add one. |
Enter SQL Statement | Specify the SQL statement for this block. Either: Enter the exact SQL statement to run. You can safely include dynamic values for query parameters in this SQL statement using the :input-param-name syntax. See Using Input Parameters as SQL Query Parameters for more information and examples. Click to open the Path Selector list and select an input parameter or other node to supply the SQL statement dynamically. See Select Fields or Paths for Block Properties with the Path
Selector for more information. Important: Supplying part of a SQL statement through the Path Selector list or using other blocks, such as String Builder, has some risks as this can allow a type of Internet attack known as SQL Injection. |
Statement Type | If the SQL statement is provided dynamically, from an input parameter or other block, set the appropriate option to indicate whether this statement is a Query statement or an Update statement (for insert, update or delete operations). |
Limit the number of records to fetch | Set this option if you want to limit the results from this SQL query or stored procedure to a specific set of rows. This is set by default to fetch the first 20 rows in Wires. This is a good practice in general to help ensure good performance for the mashup. |
Fetch records starting at row number | If you have chosen to limit the records to fetch, select or enter the number of the first record to return. Or click to open the Path Selector list and provide this number dynamically from an input parameter or other result. See Select Fields or Paths for Block Properties with the Path
Selector for more information. |
Maximum number of records to fetch | If you have chosen to limit the records to fetch, select or enter the total number of rows to return. Or click to open the Path Selector list and provide this number dynamically from an input parameter or other result. See Select Fields or Paths for Block Properties with the Path
Selector for more information. |
Fetch size to use with database connection | Select or enter the number of records that this mashup should request from this datasource at one time. Or click to open the Path Selector list and provide this number dynamically from an input parameter or other result. See Select Fields or Paths for Block Properties with the Path
Selector for more information. Setting a fetch size is generally a good idea when the dataset for this query may be large. It helps to optimize how the mashup retrieves the results, both to improve performance and ensure adequate memory for the query. |