Tersus: Non-nullable columns, default values, and padding

Non-nullable columns, default values, and paddingDate: Dec 1, 2011Tags:DB2Default ValuesStarting 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:

Add the properties "nullable" and "defaultValue" to the corresponding element (data element in a database record, or trigger of Call Procedure)

Set the nullable to "false" and defaultValue to the required value

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.PaddingStarting 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:

Add the properties 'columnSize' and 'columnType' to the corresponding element (data element in a database record, or trigger of Call Procedure)

Set the columnType property to 'CHAR'

Set the columnSize property to your field's size

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). See Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...