New Command: SET_SESSION_PARAMETER

SET_SESSION_PARAMETER OEM_TRANSLATION_STATE  allows users to programmatically enable or disable OEM to ANSI translation. Once enabled, this affects all data files used by the application. This is equivalent to adding "TRANSLATE_OEM_TO_ANSI 1" in the INT file.  SET_SESSION_PARAMETER OEM_TRANSLATION_STATE can be called at any time.

This command is only available for Flex2SQL for SQL Server. Please remember to update your Mertech.inc file before using this command.

Example 1:

#include mertech.inc

// this must be called before the LOGIN command
Load_Driver "SQL_DRV"

// disable the OEM translation
SET_SESSION_PARAMETER OEM_TO_ANSI to DFFALSE

//log on to the server
Login "server" "user" "password" "sql_drv"

Example 2:

// enable the OEM translation at SQLFlex level
Login "server" "user" "password" "sql_drv"

SET_SESSION_PARAMETER OEM_TRANSLATION_STATE to DFTRUE

Open customer

// disable the OEM translation at SQLFlex level
SET_SESSION_PARAMETER OEM_TRANSLATION_STATE to DFFALSE