Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Using Static SQL : Why Use Static SQL?

Why Use Static SQL?
Using Static SQL for your application enables DB2 accesses to be performed more quickly. One Static SQL handler is created for each TIBCO Object Service Broker DB2 table so that the Table Browser, the Table Editor, or any new application can take advantage of existing Static SQL for an individual TIBCO Object Service Broker DB2 table, rather than for an application.
Limitations to Static SQL
Static SQL is less suited to a test environment, because you must do the entire procedure each time you add new DB2 accesses to your application or change the Orders field in the TIBCO Object Service Broker DB2 table definition. If you modify another field in the definition of a TIBCO Object Service Broker DB2 table, you must repeat only Steps 3 through 8 of the following procedure.
 
Procedure Overview
To define Static SQL, complete the following tasks:
1.
2.
3.
4.
5.
6.
7.
8.
These tasks are described in the following sections.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved