[jira] [Created] (DERBY-6732) Enhance the foreignViews optional tool so that it can just create views on a single foreign schema

["Rick Hillegas (JIRA)" <ji...@apache.org>]

Rick Hillegas created DERBY-6732:
------------------------------------

             Summary: Enhance the foreignViews optional tool so that it can just create views on a single foreign schema
                 Key: DERBY-6732
                 URL: https://issues.apache.org/jira/browse/DERBY-6732
             Project: Derby
          Issue Type: Improvement
          Components: Tools
    Affects Versions: 10.12.0.0
            Reporter: Rick Hillegas


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:

{noformat}
-- 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'
 )
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)