Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Parameter Binding with INSERT Statements

When you use parameter binding, you use "?" (question mark) instead of actual values in a SQL statement. The "?" parameter must be used in place of a value for that column and not in arbitrary expressions.

The current parameter bindings are used whenever `executeUpdate()` is invoked for an INSERT statement. Parameter bindings can also be used with multi-row inserts.

Example of parameter binding:

    INSERT INTO mytable (col1, col2) VALUES (?,?),(?,?),(?,?)

The maximum number of parameters on a given INSERT statement is 999.

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.