Specifying transform groups for dynamic SQL

If you use dynamic SQL, you can set the CURRENT DEFAULT TRANSFORM GROUP special register. This special register is not used for static SQL statements or for the exchange of parameters and results with external functions or methods.

Procedure

To set the default transform group for your dynamic SQL statements, use the SET CURRENT DEFAULT TRANSFORM GROUP statement.

   SET CURRENT DEFAULT TRANSFORM GROUP = client_group;