Focus Help Topics

• New Business Intelligence Features in WebFOCUS
• Java I
• Java II
• Oracle I 
• Oracle II
   
   
• WebFocus Architecture

   

• Year 2000 Issues for Focus Users

   

• Using "Smart Dates" - New in Version 7.0.8

   

• Dynamic Allocation of a Data Set

   

• Specifying Selection Criteria

   

• Sorting

   

• Using Variables in Focus Programs
  • Using the supplied DEFINEd fields
  • Checking the length of an alphanumeric field
  • Using an EDIT mask
  • Inserting the date and time into a report heading
  • Concatenation
  • Parsing names: part 1
  • Parsing names: part 2
  • Including user-entered data in a series of Focexec's (CRTFORM)

   

• Working with Calculations in Focus
  • Calculating the span between two dates
  • SUBTOTAL vs SUB-TOTAL
  • The difference between DEFINE and COMPUTE
  • Getting the subtotal number on the same line as the SUBTOTAL label
  • Field prefixes
  • Displaying a COUNT of records in a grouped listing
  • Using COUNT when there are multiple records per person

   

• Formatting Reports
  • Report Titles
  • Page headings
  • Page footings
  • Subfoot and Subhead
  • Centering
  • Embedding fields in headings and footings
  • Positioning text - skipping lines and skipping spaces
  • Using IN to position report columns
  • Using embedded fields in a subfoot to summarize data
  • Using UNDER-LINE and SKIP-LINE to separate report groups
  • Using the ON sortfieldname clause
  • Positioning fields with IN and OVER
  • Decoding field values
  • Continuing Focus commands to more than one line

   

• Miscellaneous Topics
  • PREVIEW - Running a Focus program against a limited number of records
  • Using JOIN to extract english translations of JOB_CLASS data (example of JOIN)
  • Using a defined field to JOIN files
  • Using ISIS System Tables
  • Using MATCH to extract english translations of JOB_CLASS data (example of MATCH)
  • MATCH logic
  • The tricky SET ALL parameter
  • Suppressing page-breaks
  • Changing/Suppressing column titles
  • Matrix style summary reports
  • Reserved words and other words to avoid when programming
  • Using Order fields with repeating segments
  • The order in which Focus processes commands
  • Sample Focus programs available to all users
  • Focus programs provided by Integral, Inc. as part of HRS
  • Difference between IF and WHERE
  • Concatenating multiple files into a single file
  • SHELPROF, the Autoexec.bat file of Focus
  • How to download a file using Attachmate/ASIVT
  • How to download a file using Super Send & Receive (SSR)
  • Some of the enhancements in Focus 7.0

   

• Using TED to Create/Edit Focus Programs
  • TED Cheat Sheet (a PDF document)
  • TEDPROF - the TED profile
  • Inserting lines
  • Deleting lines
  • Recovering deleted lines
  • Changing the "current" line
  • Duplicating lines
  • Moving/copying lines
  • Splitting the TED screen
  • Splitting/joining lines
  • Locate text
  • Locate and replace text
  • Command prompt commands: SAVE, FILE, RUN

   

  ---