$jdbc

Calls the specified jdbc-driver to execute the given sql update statement.
Syntax
    $jdbc{driver_url}{sql_update}{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 update statement:

    Parameters:
      driver_url, the url of the jdbc-driver.
      sql_update, the sql update 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
    $jdbc {jdbc.odbc.SFS05}
    {create table customerDB (firstName varchar, lastName varchar, lastName varchar,)}
    {sun.jdbc.odbc.JdbcOdbcDriver}
    {username}
    {password}

    Result:
    connects to url, creates table
    "customerDB" with column "firstName",
    "lastName", "lastName" of type "varchar"
    on th eexternal database
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