Skip to main content
Ex Libris Knowledge Center

How do you run an SQL procedure?

  • Article Type: Q&A
  • Product: Aleph
  • Product Version: 20
  • Relevant for Installation Type: Dedicated-Direct; Direct; Local;

Question

How do you run an SQL procedure, such as cir_stat_bor_type.sql and the others included in the /user_scripts directory on ftp.exlibris-usa.com?

Answer

Place the proc anywhere in your u-tree (so it won't get overwritten by updates). Anywhere is fine.
From the unix directory in which you have placed the proc, enter these commands:

> s+ xxx50
SQL-xxx50> @cir_stat_bor_type

<where "xxx50" is the library you are running it for; leave off the ".sql" suffix in entering the command>

Category: System management


  • Article last edited: 10/8/2013