Page Comparison

...

DDBAPI automatically binds the values you provide to the corresponding placeholders in the prepared query.

Calling Stored Procedure

To invoke stored procedure in the database, you can employ the DBMS query language as follows:

var result = executeSQL(
    "Odbc1",
    "EXEC sp_MyProcedure @pParam1=?, @pParam2=?, @pParam3=?;",
    [1, 2.2, '3']
);
print(JSON.stringify(result));

This code snippet demonstrates the following:

• The query string uses ODBC EXEC syntax to invoke stored procedures with SQL @namedParams bound to placeholders (?) for the values you want to insert.

• The third argument to executeSQL is an array containing the values to be inserted.

• The result variable will contain information about the execution, including the number of rows affected.

DDBAPI automatically binds the values you provide to the corresponding placeholders in the prepared query.

Implementation Details

This section provides additional technical information about DDBAPI features in FIXEdge, including connection pooling, JS to SQL type mapping, and limitations.

...