Version 4.2.6 for Mainframes (Update)
 —  Parameter Reference  —

TF - Translation of Database ID/File Number

Caution:
This parameter applies to user files only. It does not apply to system files.

This Natural profile parameter can be used to translate a database ID/file number to another database ID/file number during the execution of an application. It corresponds to the macro NTTF in the parameter module NATPARM.

Possible settings production-DBID Must be in the range of 0-254, or 256-65535, or can be an asterisk (*) which stands for all DBIDs. Database ID 255 is reserved for logical system files for Software AG products, see profile parameter LFILE.
production-FNR Must be in the range of 1-65535, or an asterisk (*) which stands for all FNRs.
test-DBID Must be in the range of 0-254, or 256-65535, or can be an asterisk (*) which leaves the DBID unchanged.
test-FNR Must be in the range of 1- 65535, or an asterisk (*) which leaves the FNR unchanged.
Default setting none  
Dynamic specification yes This parameter can only be specified dynamically. In the Natural parameter module NATPARM, the macro NTTF must be used instead.
Specification within session no  
Application Programming Interface USR1034N

See SYSEXT - Natural Application Programming Interfaces in the Utilities documentation.

* Recommended.

USR2005N *

This feature is relevant when developing an application in a production environment. It enables you to develop an application in a test database and then transfer the finished application to the production database without having to change or re-compile the application.The Natural objects are cataloged with the production DBID/FNR, but whenever a database access is executed, the production DBID/FNR is translated into the test DBID/FNR according to the TF parameter specifications; that is, the test database is used. This means that testing can take place in the actual production environment, but not with production data.

The TF parameter or the NTTF macro can be specified several times so as to specify different combinations of file numbers.

The following topics are covered below:


TF Parameter Syntax

The TF profile parameter is specified as follows:

TF=(production-DBID,production-FNR,test-DBID,test-FNR)

Top of page

NTTF Macro Syntax

The NTTF macro is specified as follows:

NTTF production-DBID,production-FNR,test-DBID,test-FNR

Top of page

Example of TF Parameter

TF=(777,39,17,88),TF=(251,*,9,*)

Top of page

Example of NTTF Macro

Equivalent specification in the Natural parameter module:

NTTF 777,39,17,88
NTTF 251,*,9,*

Top of page