Implementing Siebel Business Applications on DB2 UDB for z/OS > Maintenance Considerations for z/OS >
Dynamic SQL in the Siebel Application
Traditional applications are typically based on static, hard-coded SQL. However, Siebel Business Applications generate dynamic SQL statements at run time, using the Siebel Application Object Manager and the program configuration in use by the customer. As a result, SQL statements can be as individual as the deployments in which they occur and, in some cases, dynamic SQL can become very complex, for example, joins with 30-40 tables are not uncommon.
To reduce the complexity of generated SQL (such as the number of joins, the number of columns in SELECT statements, or the number of tables in FROM statements), consider eliminating columns from the standard Siebel applets that you do not require for your business needs, especially in the most frequently used screens and views. You should also keep this consideration in mind when you customize the Siebel application by creating new objects.