Skip to main content
  • Subscribe by RSS
  • 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;


    How do you run an SQL procedure, such as cir_stat_bor_type.sql and the others included in the /user_scripts directory on


    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