See Reverse Engineering - DB2 z/OS v. 9 for more information.
See Reverse Engineering - DB2 z/OS v. 9 for more information.
Greenplum database is based on PosgtreSQL 8.2, which defines basic features and structure.
Supported features - SQL/DDL script generation, reverse engineering, HTML/RTF/PDF reports, change scripting, verification.
Permissions can be set for entities, views and functions.
Define partitions/subpartitions textually.
During reverse engineering, sub-tables of partitioned tables are filtered (the tables created because of partitioned tables). The behavior can be influenced in reverse engineering options, in checkbox Load Sub-Tables of Partitioned Tables.
Array Type - Select the Is Array Type checkbox to enable the Array Dimension box.
Array Type - Select the Is Array Type checkbox to enable the Array Dimension box.
If C is selected in Language combo box, C Language Parameters tab appears.
If internal is selected in Language combo box, Internal Language Parameters tab appears.
NO FUNCTIONALITY - Foreign key constraints are not supported in Greenplum database. They can be created but are not enforced.
Triggers can be created but the functionality is considerably limited.
Other supported objects:
Objects not supported in Toad Data Modeler:
Object specifics for Greenplum db not present in PosgtreSQL 8.2.
Writable External Table - enables the Distribution Policy tab
Web External Table - set Execute OS Command, Segment Instances, Parameter of Segment Instances
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center