This Natural profile parameter can be used to translate a database
ID/file number into another database ID/file number during the execution of an
application. It corresponds to the macro
NTTF in the
|Possible settings||See TF Parameter Syntax.|
|Dynamic specification||yes||This parameter can only be specified dynamically. In the
parameter module, the macro
|Specification within session||no|
|Application programming interface||
See SYSEXT - Natural Application Programming Interfaces in the Utilities documentation.
This parameter applies to user files only. It does not apply to system files.
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.
TF parameter or the
NTTF macro can be specified several times so as to
specify different combinations of file numbers.
TF parameters are specified,
the following applies:
The list of
TF definitions is
searched in the sequence they are defined. The first entry that exactly matches
in DBID and FNR (no asterisk) is used.
If no exact match is found, the
definitions are searched for a second time. This time, the first wildcard entry
(either DBID or FNR is an asterisk) that matches is used.
The following topics are covered below:
TF profile parameter is specified as follows:
||Identification of the production
database. An asterisk (*) can be used as a wildcard for all database IDs.
||File number of the production database. An asterisk (*) can be used as a wildcard for all file numbers.|
||Identification of the test database. An asterisk (*) can be used, which leaves the database ID unchanged.|
||File number of the test database. An asterisk (*) can be used, which leaves the file number unchanged.|
NTTF macro is specified as follows:
For explanations of the syntax elements and possible values, see TF Parameter Syntax.
Equivalent specification in the Natural parameter module:
NTTF 777,39,17,88 NTTF 251,*,9,*