Use the SSQL command to pass SQL commands through R:BASE to the foreign data source, where the commands will be interpreted and executed.
Options
SQLcommand
Specifies the SQL command to send.
About the SSQL Command
SSQL requires R:BASE to already be connected to the data source. With a few exceptions, you can use every SQL command supported by the connected data source. You cannot use commands that usually return data, such as SELECT commands.
To retrieve data from a foreign table, attach the table and use standard R:BASE commands. SSQL can be used to send structure modification commands that alter the foreign database subject to the access rights and restrictions placed on the user by the foreign database.
Additional support was added to SSQL for support in EEPs.
