To change the way the DB2 access service modifies SQL statements that are written for one database but are processed against another database, change the SQLTransformation property value, using one of these methods:
Issue a set statement to change the DB2 access service configuration until the connection is terminated or the mode is explicitly reset. For a description of set statements, see Chapter 3, “Querying and Setting Operating Values.”
Change the DB2 access service configuration file and restart the DB2 access service. For information about how to change this file, see Chapter 2, “Creating and Configuring DB2 Access Services.”
Create a new DB2 access service. For more information, see “How to create additional services”.
For a detailed list of supported SQL statements in DB2 and Adaptive Server, see Appendix B, “Using Sybase Mode Commands.”
