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

[Rick Hillegas (JIRA)]

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)