Starting with version 1.2.12, the plugins Insert, Update and Call Procedure support setting default values for non-nullable columns or stored procedure parameters. To use this feature:
If a null value is received, it will be converted to the given default value:
Note: in Insert and Update, the record the goes out of the <Inserted> or <Updated> exit will still have the null. This behavior may change in the future.
Starting with version 1.2.13, when working with DB2 on AS400, Insert, Update and Call Procedure will pad textual strings with blanks when working with fixed size text columns. To use this features:
If a value is received which is shorter than the column size, spaces will be appended to it to complete the required size.
Note: We are not aware of this feature being required for other databases (padding is usually performed automatically by the database or the JDBC driver).
For best results, use the Firefox browser..