FILE DATA EXTRACT

Previous  Top  Next

Description

T{DICT }filename;c;i;o;b

where DICT refers to the Dictionary area of the file and is optional; "filename" is the file from which the data is to extracted; "c" is how to interpret certain conditions concerning the data found; "i" is for input CONVERSION, the attribute in the file containing data to be extracted; "o" is output conversion CORRELATIVE, it is the attribute in the file containing data to be extracted; "b" (optional) is the attribute to be used instead of the data specified by the "o" parameter, during the listing of 'break-on' and 'total' lines.

Syntax

Parameter Description " V " Statement will abort with an appropriate error message if the item-id does not exist on the file or the attribute being extracted is null. " C " Extracts the data if the field is NOT null but shows the item-id if the data is null. If a multi-valued attribute is extracted OSMOSi will extract the attribute and substitute a space for each multi-value mark found. " Cn " As 'C' but 'n' is the multi-value position in the attribute, which is to be extracted. " I " Input verify only - operates like the "V" for input and like "C" for output. " O " Output verify only - operates like the "C" for input and like "V" for output. " X " As "C" but will extract data exactly as found, i.e. a null value will return a null value.

Examples

"TREPS;X;;2" with 5 in attribute 2 of the definition.

This will extract the 2nd attribute of a record in the file REPS whose item-id is the contents of attribute 5 in the current record. If the data found is null the item-id will be returned.

"TREPS;X1;;15" with 5 in attribute 2 of the definition.

This will extract the 1st multi-value element of attribute 15 of a record in the file REPS whose item-id is in attribute 5 in the current record. If the data is null, this will returned