Temenos Transact RDBMS Views and Indices

This section describes the creation and use of views and indices on tables created in RDBMS as part of the Temenos Transact RDBMS implementation.

NOTE: You need to be aware of creating data file of XMLrdbms (RDBMS stub file) and extended dictionaries.

The examples in this document use the CUSTOMER file layout. The field definitions in this section are not definite for CUSTOMER but merely examples.

Overview

This section provides a brief overview to the supported data types, short tag and XSD schema, advantages and disadvantages of indices and need for views.

Index Creation

This section provides the details for creating an index on an RDBMS stub file such as the syntaxes, left and right justification differences and index samples for the Oracle, DB2, and SQL servers.

View, Table / Index Statistics Creation

This section provides details about the views, table/index statistics creation in RDBMS.


Bookmark Name Actions
Feedback
x