Description
Execute a SQL query that returns a scalar float value. If the query returns a dataset, the value of the first column in the first row is returned.
Syntax
ExecuteSqlFloat(connection_id, sql_query[, param1] [,…paramN])
Arguments
connection_id (string) - The unique identifier of the connection to use to execute the query. You can find it in the connection's page.
sql_query - String expression that evaluates to a query that returns a scalar value.
param11 ... paramN - optional parameters to pass to the query. Use ? as placeholder in the query.
Examples
ExecuteSqlFloat('mysql_55','SELECT price FROM products WHERE product_id = ?', product_id)
Notes
This function only executes in job runtime. When validating a package with variables that use the function or in X-console, the function returns null.
Return value datatype
Double
Impact of null value
If the connection_id or sql_query are null, null is returned.