Pragma Functions

Pragma functions are special SQL commands for configuring and managing the ERPL extension runtime behavior.

Available Functions

Configuration Management

• sap_rfc_set_ini_path - Specifies the path to the INI configuration file.
• sap_rfc_reload_ini_file - Reloads the INI configuration file without restarting DuckDB.

Trace and Debugging

• sap_rfc_set_trace_level - Sets the trace level for debugging and analysis purposes.
• sap_rfc_set_trace_dir - Specifies the directory where trace files should be stored.
• sap_rfc_set_maximum_trace_file_size - Sets the maximum size for trace files.
• sap_rfc_set_maximum_stored_trace_files - Defines the maximum number of trace files to keep.

Connection and Utility

• sap_rfc_ping - Checks the connectivity to the SAP system.

To inspect a function module's interface, use the table function sap_rfc_describe_function('FUNC_NAME').

Usage Examples

-- Set the trace level to verbose
PRAGMA sap_rfc_set_trace_level(2);

-- Check SAP connectivity
PRAGMA sap_rfc_ping;

-- Set the INI configuration file path
PRAGMA sap_rfc_set_ini_path("/path/to/config.ini");

For detailed documentation on each function, see the individual function pages linked above.