TRTMIG processing: TRTMIG
TABNAME: Changing the temporary table name
This entry point is located in the TRTMIG processing.
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 beginning 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 provide 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.
It is used 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 the code list above)
FILTRELIN Value 1 indicates that there will be a filter in the loop via the VERIFSEL entry point.
CRITERESPE Clause Where to be added to the related query.Depending on the flow type, the clause may use the abbreviation on the file mentioned in the above table.
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 outVERIFSEL: Used to filter the lines after the global For has completed reading
This entry point is located in the TRTMIG processing.
It is used by the overall flow migration procedures.
It is used to create 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
The F class corresponding to the flow (above code list) is loaded.
FLUX Identifies the flow that calls the EP (see the code list above)
ISVALID Set 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 the CRITSEL entry point