Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6732

Enhance the foreignViews optional tool so that it can just create views on a single foreign schema

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.12.1.1
    • None
    • Tools
    • None
    • Normal

    Description

      Right now, the foreignViews optional tool creates views on all of the user tables in a foreign database. Sometimes all you want is one or two schemas. The bulk creation of views can also fail for databases which have weird, non-ANSI/ISO tables. We could add another trailing argument to the tool which limits view creation to a single schema. Something like this:

      -- register like this
      call syscs_util.syscs_register_tool
      (
        'foreignViews',
        true,
        'foreignDatabaseURL',
        'XYZ_',    -- the prefix added to the local (Derby) schema names
        'foreignSchemaName'
       )
      
      and
      
      -- unregister like this
      call syscs_util.syscs_register_tool
      (
        'foreignViews',
        false,
        'foreignDatabaseURL',
        'XYZ_',    // the prefix added to the local (Derby) schema names
        'foreignSchemaName'
       )
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: