SQL/DDL Implementation › Implementing Restrictor and Positioner Functionality › YSQLWHR Model Value

YSQLWHR Model Value

The SQL Where Clause (YSQLWHR) model value lets you specify the method that is more efficient for your target database. The two valid values are:

• *OR—Generate WHERE clauses using OR logic to implement restrictor and positioner functionality. This is the shipped default.
• *NOT—Generate WHERE clauses using NOT logic to implement restrictor and positioner functionality.

The end result of the executing application is the same whether you specify *OR or *NOT for YSQLWHR. All that changes is the structure of WHERE clauses in the generated application. This can result in improved performance depending on the target RDBMS.

Note: The OR and NOT logical operators are used only when there is more than one positioner. For example, if there were two restrictors and one positioner, both *OR and *NOT would generate identical SQL statements.