Entry points > Module Supervisor > Standard script TRTMIG 

TABNAME: Changing the temporary table name

This entry point is located in the TRTMIG.process.

It is used by the overall flow migration procedures.

It is used to change the temporary table name as selected for a given table.

This entry point must be defined in the application root folder.

Context and operating method

TRANSACTION

There is no transaction in progress.

Log file                        

There is an open log file.

Different call cases

Upon creating temporary tables, it makes it possible to modify the temporary table name as selected for a table.

Then, it is used by the overall optimized migration flows.

Available variables and masks

PDOSSIER Identifies the folder where work is to be carried out

PTABLE Provides the original table name

MTABLE Contains the temporary table name as selected for the PTABLE table. This variable should be modified in order to give another name.

Naming temporary tables

The temporary tables are created by adding letter U at the begining of the table code.

If the initial code of the table has 10 characters, the first letter is deleted before addition of letter U.

For some tables, letter U is also added at the end of the code for uniqueness purposes.


TABABR: Changing the temporary table abbreviation

This entry point is located in the TRTMIG.processing.

It is used by the overall flow migration procedures.

It makes it possible to change the selected abbreviation for a given temporary table.

This entry point must be defined in the application root folder.

Context and operating method

TRANSACTION

There is no transaction in progress.

Log file                        

There is an open log file.

Different call cases

Upon creating temporary tables, it makes it possible to modify the abbreviation as selected for a temporary table.

Then, it is used by the overall optimized migration flows.

Available variables and masks

PDOSSIER Identifies the folder where work is to be carried out

PTABLE Provides the original table name

MTABLE Gives the temporary table name

MABR Contains the abbreviation as selected for MTABLE temporary table. This variable should be modified in order to give another abbreviation.

CRITSEL: Makes it possible to add an Sql selection criterion on the global For

This entry point is located in the TRTMIG.processing.

It is used by the overall flow migration procedures.

Makes it possible to add

- a global selection clause to filter the records read by the migration flow,

- a HINT to be used on the query for record reading.

This entry point must be defined in the application root folder.

Context and operating method

TRANSACTION

There is no transaction in progress.

Log file                        

There is an open log file.

Available variables and masks

FLUX Identifies the flow that calls the EP (see above code list)

FILTRELIN Value 1 indicates that there will be a filter in the loop via entry point VERIFSEL.

CRITERESPE Clause Where to be added to the related query. According to the flow type, the clause may use the abbreviation on the file mentioned in the above grid.

HINTSPE key to be used to position a Hint on the query.

Different call cases

[F:ADS]DOSSIER contains the folder where work is carried out

VERIFSEL: Makes it possible to filter the lines after the global For has comple

This entry point is located in the TRTMIG.processing.

It is used by the overall flow migration procedures.

It is used to make a filter on the records in the loop, after reading.

This entry point must be defined in the application root folder.

Context and operating method

TRANSACTION

There is one transaction in progress.

Log file                        

There is an open log file.

Available variables and masks

Class F corresponding to the flow (above code list) is loaded.

FLUX Identifies the flow that calls the EP (see above code list)

ISVALIDSet to value 0 so that the record read should not be processed by the migration procedure.

[F:ADS]DOSSIER contains the folder where work is carried out

Note

This entry point will not be called unless variable FILTRELIN is positioned to 1, for the flow, in CRITSEL entry point

Different call cases