Configure SQL Syntax Transformations

The DRDA Service will utilize a set of SQL command syntax transformers. The primary SQL transformer is within the MsDrdaService.exe and is referred to as the SQL parser, providing core transformations for most commonly required syntax. The secondary SQL transformer is within the SQL Server database .NET CLR (Common Language Runtime), where the MsDrdaService setup program will install optional DB2 to SQL Server mapped functions. The DRDA Service supports STRIP, TRANSLATE, HEX, and CHAR mapped CLR functions.

SQL Transformer

The sqlTransforms attribute instructs the DRDA Service to utilize internal service or external CLR-based SQL transforms. This optional attribute accepts a string value of Service or Clr. The default value is Service.

Note

To enable SQL Server CLR Integration, execute the following stored procedure.

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'clr enabled', 1;  
GO  
RECONFIGURE;  
GO  

SQL Server stored procedure to enable CLR integration.

For more information, see CLR Integration - Enabling.

SQL Transformer Unicode Output

The SQL Transformer will output NCHAR and NVARCHAR for all string values. The sqlTransformsUnicodeOutput attribute instructs the DRDA Service to encode output from the CLR-based SQL transformer in Unicode or ANSI. This optional attribute accepts a Boolean value. The default value is false, which instructs the DRDA Service to output ANSI CHAR and VARCHAR strings.