FOCUS Fridays VUG - Synonyms Part 1, JOIN Basics, Instream MAINTAIN Apps

We start this new year looking at some of the FOCUS/WebFOCUS basics:

Synonym in Depth – FILE specs – The Master file or synonym is the key to using the FOCUS language with any file. This in-depth look at synonym will go beyond the automatic view of the file that the tools create and will demonstrate how you can use the synonym to handle difficult cases. We start with the FILE specification and its characteristics including ACCESS, SUFFIX, and MFD_PROFILE.

JOIN-Basics - Combining files to get all the data needed for a report is always a hot topic. Join us to learn the basics of the JOIN command along with discussing the differences between a FOCUS Managed JOIN and an RDBMS Managed JOIN.

Instream Maintain Applications - The Maintain language is a powerful tool for manipulating data. There are many instances when a simple task can be done with just code and no forms. These tasks include: Changing database types, changing field formats and migrating databases.