dbQuery
Version 20.0.7681
dbQuery
Version 20.0.7681
Executes a query against the database.
Required Parameters
- driver: The JDBC driver class name in the Java version or the ADO.NET provider name in the .NET version.
- conn: The connection string or database URL.
- query: The SQL query string.
Optional Parameters
- user: The database username passed to initialize the JDBC connection object. This can also be set in the JDBC URL.
- password: The database password passed to initialize the JDBC connection object. This can also be set in the JDBC URL.
- enforceparameterizedquery: Enforce the parameterized verification for the SQL statement.
- commandtimeout: CommandTimeout, in seconds, for the operation to complete. Zero (0) means no timeout. This attribute defaults to 60. The default value is ‘60’.
- fromrow: Number of rows to skip from start. The default value is ‘0’.
- maxrows: Maximum number of rows to return from the database. Set to -1 to get all results. The default value is ‘-1’.
- returnrows: Indicates whether this SQL statement returns rows. For instance, SELECT queries or a stored procedure can return rows, but an update will not. This attribute defaults to AUTO. The allowed values are ‘AUTO, YES, NO’. The default value is ‘AUTO’.
- paramname#: Parameter names in the SQL statement.
- paramvalue#: Parameter values in the SQL statement.
- transactionid: The Id of the transaction.
Output Attributes
- db:*: Output varies based upon the query.