
Natural for UNIX	Version 8.3.7 for UNIX	SEARCH CONTENTS \| PDF BOOKS \| HOME UP PREV NEXT

— Parameter Reference —

TF - Translation of Database ID/File Number

This Natural profile parameter is used to translate the database ID/file number of a production database into the database ID/file number of a test database.

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

Possible settings	`production-DBID`	`0 - 65535`, except `255`, or can be an asterisk () which stands for all DBIDs. Note:* DBID `255` is reserved for logical system files for Software AG products, see profile parameter `LFILE`.
	`production-FNR`	`1 - 5000`, or an asterisk (*) which stands for all FNRs.
	`test-DBID`	`0 - 65535`, except `255`.
	`test-FNR`	`1 - 5000`
Default setting	none
Dynamic specification	yes	This parameter can be specified dynamically and in the Natural parameter file `NATPARM`.
Specification within session	no

Notes:

The translation of file number 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 transfer is done by a translation of the application's database identification (DBID) and file number (FNR): with the TF parameter, you specify the production DBID/FNR and the test DBID/FNR. The Natural objects are then cataloged with the production DBID/FNR, but whenever a database access is executed, the production DBID/FNR is translated into the test DBID/FNR; 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 asterisk (*) notation for production-DBID and production-FNR is mutually exclusive.

TF Parameter Syntax

The parameter is specified as follows:

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

The TF parameter can be specified several times. Existing specifications are displayed in a corresponding list box.

Notes:

Production and test databases must be of the same type (Adabas/Adabas, for example).
If the database type is not specified in NATPARM, the Adabas is used as default type; that is, SQL and XML databases must be specified explicitly.
For SQL and XML databases, the file number must always be set to 1. The DBID must be in the range of 0-254.
The profile parameter UDB (User Database ID) is evaluated before the TF parameter is evaluated.

SEARCH CONTENTS | PDF BOOKS | HOME UP PREV NEXT