After configuring the SQL database backend connections in Management Cockpit, you may need to make modifications to the SqlBe.ini configuration file. The SqlBe.ini is the default query initialization file that is provided by the server installer. You can modify the file for a single application, or use it as a template to create other query initialization files for applications that have multiple SQL database system connection types.
Query initialization files are generally set up initially by application developers, or as the result of development efforts and standard application needs. Before making any changes to the settings, you should have a full understanding of how your changes might impact application behavior. SAP recommends that, rather than changing the Query initialization file, you instead make your changes to the scripts it references.
Any changes you make, either to the settings in this file or to those scripts it references, are generally the result of specific implementation requirements. Items such as user validation or auditing requirements can dictate when and what modifications may be necessary.
sql sql\custom
These two separate folders allow for both standard and customized processing. For an application implementation, the sql folder contains the standard scripts that are provided with the application installer. Make a copy of each script before you make any changes to it, and then save the new version in the sql\custom folder.
When processing scripts listed in the SqlBe.ini file, SAP Mobile Platform Server looks first in the sql\custom folder. If a script is not found in the \custom folder, SAP Mobile Platform Server then looks for the same file in the sql folder.
To return to default processing, simply move or rename the script file. The next time SAP Mobile Platform Server looks for the script, it finds the default version, and executes it.