Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Holds DDL (Data Definition Language) and DML (Data Manipulation Language) statements that can be performed during installation or uninstallation, such as stored procedures.

AttributeDefinition
statementRequired. Defines the DDL statement.
dbms

Optional. the RDBMS type on which the DDL generates. Must be one of the following:

  • oracle
  • mssql
  • ""

If left empty (""), the DDL is created on all relational database management systems (RDBMS).

version

Optional. The RDBMS version on which the DDL generates. Should have the format 8.1. ... If left empty, the DDL is created on all RDBMS versions.

event

Optional. The RDBMS version on which the DDL generates. Must be one of the following:

  • INSTALL Default. During the installation process only.
  • UNINSTALL During the uninstallation process only.
  • PREINSTALL Before the installation process.
  • PREUNINSTALL Before the uninstallation process.

<view-definition> tag

Holds all the parameters required for a view definition.

AttributeDefinition
nameRequired. Holds the view name. The name should follow the naming conventions specified in Naming conventions.
type

Required. Specifies the view type and can hold one of the following values:

  • STATISTICS A PMDB view that holds information about certain database activity, summarized into hours or time slices.
  • INTERNAL A PMDB view that keeps any other, non-statistical information.
view-columnsRequired. Its value is in the view columns separated by blanks. The number of columns should be equal to the number selected in the as-query attribute.
as-queryRequired. Specifies the select table that defines the view.
check-optionOptional. Default value is FALSE. If the value is TRUE, only modifications that are visible through the view are allowed, meaning that INSERT and UPDATE statements are valid only if the affected rows can be retrieved by the view afterward.
Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse