Uniface User Forum

 View Only
  • 1.  Switching to procs:on

    Posted 10-20-2021 10:19
    Edited by Iain Sharp 10-26-2021 06:48

    So, if I have a mature database, and I want to look at using the procs:on setting in the driver (MSS), is there any way of generating just the procs creation scripts? Or do I have to generate the entire DB creation scripts, and then edit out the table creates? 


    Iain Sharp
    Head of Technical Services
    Pci Systems Ltd
    Sheffield United Kingdom

  • 2.  RE: Switching to procs:on

    Posted 10-27-2021 12:43

    The MSS database driver creates the stored procedure as part of the create table scripts. At this moment there is no straight forward way to just generate the scripts for creating the stored procedures. You therefore have to use option 2: "generate the entire DB creation scripts, and then edit out the table creates".

    There might be a way to automate the edit out of the table creates: if you generate two create table script files, one with procs:on and one with procs:off then you could create a patch file with a compare tool like e.g. WinMerge and delete the extra markup like described here. Just an idea.

    I hope this helps.


    Daniel Iseli
    Rocket Internal - All Brands
    Geneva Switzerland