$jdbcQuery

Calls the specified jdbc-driver to execute the given sql query statement.
Syntax
    $jdbcQuery{driver_url}{sql_query}{driver_name}{par_1_name}{par_1_value}{par_2_name}{par_2_value} ... {par_n_name}{par_n_value}
DocumentationCalls the specified jdbc-driver to execute the given sql query statement:

    Parameters:
      driver_url, the url of the jdbc-driver.
      sql_query, the sql query statement to execute.
      driver_name, a optional parameter to specify the classname of the jdbc-driver; defaults to sun.jdbc.odbc.JdbcOdbcDriver.
      par_1_xxx through par_n_xxx, additional parameters for the jdbc-driver given as key-value pairs.
Examples
    $jdbcQuery{jdbc.odbc.SFS05}
    {SELECT * from customerDB}
    {sun.jdbc.odbc.JdbcOdbcDriver}
    {password}
    {username}

    Result:
    connects to url, selects all from table "customerDB"
GroupSQL
Minimum required transaction-mode:READ=SQL
Required scripting permission of the developerPERMISSION_FL_EXPERT
Minimum parameters2
Maximum parameters <unlimited>
[Index] | [API-Index] | [Index-de] | © SITEFORUM Group, Germany | powered by SITEFORUM