Name

VAD_LOAD_SQL_FILE — Loads SQL file and executes its content's statements.

Synopsis

DB.DBA. VAD_LOAD_SQL_FILE ( in sql_file_name varchar ,
  in grouping integer ,
  in report_errors varchar ,
  in is_dav integer );
 

Description

Loads SQL file ( can be regular file or DAV resource ) and then splits its content into single statements and executes them one by one. Along the process, the function makes needed reports and changes 'VAD_errcount' registry variable.

Parameters

sql_file_name

For files, this parameter is either absolute or relative to server's working directory. The directory should be readable according to the virtuoso.ini settings. For DAV resources, the sql_file_name is always absolute: ('/DAV/<folder-name>...').

grouping

Always set this parameter to 1.

report_errors

The supported values for this parameter are:

  • 'report' - to log errors and continue or:

  • 'signal' - at the very first error, break the loading and resignal it.

is_dav

This parameter is 0 for plain file and 1 for resource loaded in DAV.

Examples

Example 24.437. Simple Use

DB.DBA.VAD_LOAD_SQL_FILE ('./conductor/vdir_helper.sql', 1, 'report', 0);