Renaming a temporary table name to actual table name

A temporary table space contains restructured data. This topic shows how you can rename this temporary table to actual table for online transactions in Temenos Transact.

Procedure

1. Open SQL prompt from DBtools.
2. Use the below command for renaming the temporary tables.

   ALTER TABLE (Temporary table name) RENAME TO (actual table name)

   

Example

Drop actual table then run the below command.

ALTER TABLE FBNK_FUNDS_TRANSFER003 RENAME TO FBNK_FUNDS_TRANSFER;

Restructured data view from Temenos Transact:

Sample screen shots given below on restructured data before and after, according to restructure definitions.

The below screen shot shows the restructure definitions that are considered for the restructure process.

The below FUNDS.TRANSFER-201809 example shows you the list of data items from corresponding table that are restructured according to the criteria defined in restructure definition.

The below screen shot shows the records with FED.FUNDS as NO before restructure process.

The below screen shot shows the records with FED.FUNDS as YES after restructure process.

Audit section INPUTTER field updated with restructure definition ID.