db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-6732) Enhance the foreignViews optional tool so that it can just create views on a single foreign schema
Date Tue, 09 Sep 2014 18:15:29 GMT
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)

Mime
View raw message