Previous Topic: Choosing an Execution MethodNext Topic: Using SQL Mode Reporting


Specifying an Output Destination

When you execute a query online, you can specify multiple destinations for your execution output.

If you execute a query in batch, you can only specify a printer as the output destination, and not the terminal screen. For more information about batch execution, see Executing in Batch.

Options

The following figure compares the output destinations available with online and batch execution.

Destination

Advantages

Disadvantages

Video
Terminal

  • Immediate results
  • Can change total
    options without reexecuting
  • Can change report
    format without reexecuting
  • Can go directly to any page
  • Must scroll to see report that is wider or longer than your terminal screen

Network Printer

  • Get a hardcopy
  • Can see all of a long or wide report
  • Output is probably faster than system printer
  • Must wait turn in print queue
  • Paper might not be wide enough

System Printer

  • Get a hardcopy
  • Can see all of long or
    wide reports
  • Best for wide reports
  • Might have laser printer
  • Best for large volume
  • Probably slowest output turnaround
  • Cannot be used if the query contains a DISPLAY statement

Hints

Printer time and report retrieval time are site-specific. You might find, for instance, that your system printer produces faster turn around time than your network printer. When specifying a printer as your report destination, please remember these things: