To watch a video on this topic CLICK HERE.
Search for and extract specific information contained within the spool file. Allows for results to be displayed in PDF, Grid, or Txt format.
Example: Display Type of PDF View using the AND logic and Page results.
Example: Display Type of Grid View using the OR logic and Line results.
Choosing the Display Type of Grid View provides the option ‘Grid to Excel’ allowing the results to be downloaded to an Excel spreadsheet.
To specify specific lines and columns to include in the Grid/XLS view, setup a XLS Specification by user and/or profile.
From an IBM i command line, type GO IMAGE
- Select 3: Spool File Menu
- Select 2: Maintain Form Profile
- F10 = XLS Specs
- F9 = Add Record
Example: Display Type of Txt View without any search criteria.