File Translation Conversion (T)

File Translation (Tfile)

Top  Previous  Next

 

The T conversion code uses the source data as a record id to the named file and returns data from this record.

 

 

The format of the conversion code is

 

Tfile;cv;i;o

 

where

 

fileis the file name. This may be prefixed by either DICT followed by a space or by an asterisk with no space to reference the dictionary part of the file. Where necessary to avoid ambiguity, the file name may be enclosed in quotes.
cidentifies the action to be taken if the requested record does not exist of the field to be extracted is null. This is a single letter:
CReturns the record id.
VDisplays a warning message and returns a null value.
XReturns a null value
ILike V for input conversion, C for output conversion
O Like C for input conversion, V for output conversion
vspecifies the value position to be extracted from the returned data. If omitted, all values are returned with value and subvalue marks replaced by spaces.
ispecifies the field position of the data to be returned when performing an input conversion.
ospecifies the field position of the data to be returned when performing an output conversion.

 

This conversion code is closely related to the TRANS() function. Where possible, TRANS() should be used in preference to the T conversion code for best performance.