Legacy Application Modernization: Key Steps, Benefits & Best Practices
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
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
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...