FOCUS Fridays VUG - MATCH - the Other JOIN, FML Hierarchy, and Stack Searching, Sorting and Unique values
FOCUS Fridays continues its exploration of the FOCUS/WebFOCUS language this month by covering the uses of the other file connection command - MATCH FILE, the FML Hierarchy extension that simplifies hierarchical reporting, and the use of the Stack in MAINTAIN for searching and sorting.
MATCH - the other JOIN
JOIN is the primary universal syntax that allows us to connect the data in two files. FOCUS/WebFOCUS also supports the MATCH syntax which allows the connection and merging of data in multiple files. In this session we will cover some of the uses of this command.
This session will extend your knowledge of the financial reporting language by delving into the hierarchical reporting capabilities that are available.
Stack Searching, Sorting and Unique values
Stacks are used to collect and display data. This presentation focuses on case insensitive searching, sorting and removing duplicate values from the stack before display.