Number_of_Update_Columns (Additional Parameter)

Allowed values

positive integer

The default value is 10. This is the USoft factory value. It applies if you have not set this deployment parameter to a different value.

Context

This parameter may be set for all 3 deployment configuration contexts: Client Server, RunBatch, and Rules Service.

You can set this parameter in the Additional Parameters list at the bottom of the tab page for each context.

Explanation

This is where you specify what the UPDATE statements generated by USoft Developer will look like. For tables with column counts lower then this value the conceptual processor will generate UPDATE statements that update all columns of the table. This has the advantage that RDBMS cursors created for these statements can be reused. This increases performance.

If the column count of a table is equal to or higher than this value, UPDATE statements on this table will only update the columns actually updated.