Download User Manual

Transcript
Suprtool Issues and Solutions
A Suprtool Task
Suprtool's primary function is to extract data quickly; its focus is batch extraction.
The key principle is: the bigger the input data source and the smaller the subset of
data selected, the more performance improves.
Your aim is to replace serial reads and selection with Suprtool. To do this, break
your task into components: an input choice, some processing selections, and the
output choice.
Input Choices
Suprtool reads fixed-length data files. You can create self-describing files with
Suprtool's Query or Link output options. It is easier to work with self-describing files
because they have information about the fields in each input record.
Often you select a subset of the input records using the If command. Only selected
records are passed to the processing stage and the output choice.
Processing Selections
If you do not specify any processing, the input records are quickly copied to the
output choice. Some of your processing choices are
1.
Sort the records into ascending or descending sequence (Sort or Key).
No records are output until all of the selected input records have been
sorted.
2.
Total one or more input record fields (Total).
3.
Remove or select duplicate records (Duplicate).
Output Choices
Usually you wish to extract a subset of your records to feed into a report program, so
the default output file is a data file. The default output file format matches the input
file format, unless you use the Extract command. You can specify different formats
for the output file by qualifying the Output command. To have readable ASCII
output, use "output xxx,ascii". To produce "self-describing" files, use Output
xxx,Link.
62 • Suprtool Issues and Solutions
Suprtool 5.0 for HP-UX