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
Tags: Sessions