BroadSQLLIB RUN
Runs a Script stored in the Scripts Library, the same way @ does. The name is a path relative to the library root, exactly as written: LIB RUN maintenance/foo.bsql runs maintenance/foo.bsql. No extension is added and the path cannot leave the library. Arguments are named, name=value, and read in the Script as ${name}.
Arguments
<script> (mandatory) a path relative to the Scripts Library, then optional name=value arguments
Examples
LIB RUN maintenance/cleanup.bsql
LIB RUN "folder/my script.bsql" region='EU' year=2026Notes
Runs a Script from the Scripts Library: LIB RUN <script> [name=value ...].
script is a path relative to the Scripts Library root, taken exactly as written: LIB RUN foo.bsql runs <ScriptsLibrary>/foo.bsql, LIB RUN maintenance/foo.bsql runs <ScriptsLibrary>/maintenance/foo.bsql. No extension is added, no alias or file-name search is done, and the path cannot leave the library (use @<path> for a Script located elsewhere).
Arguments are named, as for @: LIB RUN report.bsql customer_id=42 country='FR' assigns the SQL scripting variables customer_id and country before the Script starts, and the Script reads them as ${customer_id} and ${country}. Positional parameters %1 to %9 were removed. Execution, arguments, the final status line and errors are those of @; only the reference form differs.
See Named Script arguments in the SQL scripting guide.
Last modified in release 5.3.3.