Folders for External Functions
It is possible to call external procedures implemented using shared libraries (.DLL in Windows, .SO in Linux) within procedures and triggers run on the 602SQL Server. This mechanism can be dangerous if the server is allowed to call procedures from any library. It would even be possible to delete files using the standard Windows API.
602SQL only allows external functions to be executed from libraries in specific folders (either the 602SQL installation folder or other explicitly specified folders).
You can set the shared library folder in the Runtime parameters window, DLL/SO Directories. It is not required to specify the 602SQL installation folder on Windows, however, it is required on Linux.
The folder names are stored on the server properties DIRn numbered starting from 1. These properties can be edited using the Set_property_value function.
