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

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.12.1.1
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None
    • Urgency:
      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

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

                Dates

                • Created:
                  Updated: