Type Code F

Previous  Top  Next

Description

This will call a File Update routine that has been defined using the OSMOSi File Update Process routine. The Update routine is stored in "_PROCS". Each file that is to be updated has a record with a type (or first attribute) of FS with details of how it is to be affected.

Syntax

The format of the "_PROCS" record is:

Attribute Description 1 "F" 2 Description of the process 3 Internal use 4 Internal use 5 Multi-value list of files to be updated - each file will have a separate _PROCS record with FS (file segment) in attribute 1 (see below) 14 Release Information (release, date created and date last amended) 19 System Id (optional)

The format of the FS record in "_PROCS" is:

Attribute Description 1 "FS" 2 Multi-value position 1 = Dictionary file name for the Query to use Multi-value position 2 = Data file name (if different to the dictionary name) 3 Field name in the original file containing the key to the file to be updated 4 "U" - update records in the file; "D" - delete records from the file 5 Criteria for updating the file 6 Process to be run prior to the update/delete starts 7 List of field names to be updated 8 Method of updating the field (+,-,*,/,I,Ixx (where xx is the sort method eg IAL insert into a dynamic array that is sorted ascending left justified) a "(N" indicates that the item should not be inserted if it exists) 9 Expressions to update each field in 7 10-18 Internal use 19 System Id (optional)

Remarks

None