Specifying transform groups for static SQL

For static SQL, use the TRANSFORM GROUP option on the PRECOMPILE or BIND command to specify the static transform group used by static SQL statements to exchange values of various types with host programs.

About this task

Static transform groups do not apply to dynamic SQL statements or to the exchange of parameters and results with external functions or methods.

Procedure

To specify the static transform group on the PRECOMPILE or BIND command, use the TRANSFORM GROUP clause:

   PRECOMPILE ...
   TRANSFORM GROUP client_group
   ... ;