View Revisions: Issue #2655

Summary 0002655: Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields
Revision 2018-10-17 18:30 by hanes
Description Create parameters to control the data type and size for sym_data field: row_data, pk_data, old_data, and external_data. For row_data, pk_data, and old_data, they are by default CLOB, but the user might want them to VARCHAR with a size, which can increase the performance. For external_data, it is by default VARCHAR(50), but the user might want it to be larger.

This comes up in various database on various tables. sym_trigger is another spot where the table can be too "wide" for a database.
Revision 2016-06-29 16:11 by elong
Description Create parameters to control the data type and size for sym_data field: row_data, pk_data, old_data, and external_data. For row_data, pk_data, and old_data, they are by default CLOB, but the user might want them to VARCHAR with a size, which can increase the performance. For external_data, it is by default VARCHAR(50), but the user might want it to be larger.