SCRIPT RUN

Core command SC RU SCRU

Runs a saved script from the scripts catalog: sugar for @<resolved path>, no %N parameter substitution

Arguments

<name> (mandatory) a file name, @alias, or search term

Examples

SCRIPT RUN DAILY.SQL

Notes

Runs a saved script from the scripts catalog: SCRIPT RUN <name>.

Sugar for the existing @<path> mechanism (see CommandExternalFile): name is resolved against the Scripts catalog (relative path, @alias, or unambiguous bare file name, same resolution as LIB RUN/SCRIPT SHOW), then every statement in the resolved file is run exactly as @<path> would run it: runScriptFile(String) is the exact same code path, so behavior is identical. Unlike LIB RUN, there is no %N positional parameter substitution, since a script is an arbitrary sequence of BroadSQL/SQL statements, not a single parameterized query (see docs/SQL_LIBRARY_AND_SCRIPTS.md, section 2). Also prints a one-line warning, without refusing to run, for each of the entry's @instance/@environment metadata that doesn't match the current connection's instance/environment (section 4).

Last modified in release 5.0.8.