|
|
|
Dovetail SchemaEditor customers using Amdocs 6 or later databases can specify database specific SQL statements for their SQL Views.
XML format for the databaseSpecificSql object
The databaseSpecificSql element is a child of the sqlView object.
<databaseSpecificSql description="sql strings for this sqlView" isUserDefined="true">
<sql targetDatabase="mssql" ><![CDATA[(select id_number from table_contact)]]></sql>
<sql targetDatabase="oracle" ><![CDATA[(select id_number from table_contact)]]></sql>
<sql targetDatabase="db2" ><![CDATA[(select id_number from table_contact)]]></sql>
</databaseSpecificSql>
Attribute Name |
Required |
Default |
Description |
|---|---|---|---|
description |
No |
|
Description of the database specific sql statements and their purpose. |
isUserDefined |
No |
true |
Indicates if this databaseSpecificSql element has been defined by the customer. |
sql (element) |
At least one is required. |
|
One or more sql elements can be used to define the database specific sql statements for the target database. |
targetDatabase |
Yes |
|
Each sql element requires that you select which database your database specific sql statement is targeting. Valid values are:
|
See Also |
Next |