If the target LAN service of your CSA is a DirectConnect instance, SQL transformation is performed as configured through a property setting on DirectConnect.
The CSA must send requests in SQL appropriate for the transformation level set in the current DirectConnect configuration. Otherwise, before the CSA sends the request it must send a SET statement to set the correct transformation level. For information about SET statements, see the Mainframe Connect DirectConnect for z/OS Option User's Guide for DB2 Access Services appropriate for your environment.
Similarly, any data that a CSA retrieves through a DirectConnect instance is converted to Adaptive Server Enterprise format as specified by the current transformation settings. The CSA can send SET statements to define the desired conversion settings.
