Combination of files in the Results-Output section

===========================

Searching Dialog: Output Commands: Display, Type, Print, Report

Scope

Dialog Output Functions (Commands)

Functions / Commands
Usage
Examples, Notes

sort records

sort set/<records> /<fields>

  • You can sort by multiple fields.
  • The sort is ascending, unless you add a d at the end.
  • sort s28/all/au,ti

display records

d s3/9/all

d s8/2/19

d 1/6/2-9

  • A screen-by-screen display
  • d[set #]/[format]/ [item #s]

type

t s2/4/1-31

  • A continuous display of results

report

report s8/2/co,py,sa

  • Geneates a tabular display of the fields that you select.

print

pr s1/2/3

pr s3/5/3-9/ti

  • Offers varied ways to deliver or print selected search results.
  • Use pr cancel to cancel a print command.
===========================

Searching Dialog: Command & Web Output Formats

Scope

Standard Output Formula

Standard Output Formats

Example Custom Output Formats

DialogWeb Equivalent Formats

===========================

Dialog: Sorting Search Results

Scope

Command

Usage

===========================

Searching Dialog:
Improving Search Results by Eliminating Duplicates

Scope

How to Elimate Duplicate Records

Using id and rd operators

Command
Operator
USAGE
identify duplicates
id
id s11 - Creates a set of records with all duplicate ones grouped together.
remove duplicates
rd
rd s3 - Removes duplicates in set 3

NOTE: Generally, you will just be using this operator, as this reduces the number of results that you may need to display.

NOTE: Only sets created by rd can be used in subsequent select (s) commands.

Using the not operator

===========================

Searching Dialog: Search Results: Using Search Save & Execute

Scope: Search*Save

Command: Save

SAVE

  • Stores strategy permanently until deleted. Serial numbers begin with S.

SAVE TEMP
SAVE TEMP <name>

  • Stores strategy for seven days; automatically deleted.
  • Serial number begins with T.

SAVE SDI

  • Stores strategy and PRINT command(s) until deleted.
  • PRINT command required.
  • Automatically executes strategy against each new update to database in which entered.
  • Serial number begins with D.

To use Saved Searches

Command: MAPxx

MAPxx

  • Creates a Search*Save of data extracted for field xx of MAPxx TEMP records already retrieved.

MAPxx STEPS

 

  • If STEPS is used, data is formatted into separate search statements in Search*Save.

Command: Recall

Recall is useful for reviewing the serial numbers and/or names of the saved searches that you stored under your password. The displayed list shows the serial number or name, the date and time saved, and the number of command lines in the search.

RECALL nnnnn

  • Recalls Search*Save nnnnn, displaying all set-producing commands and comment lines, without executing the search.

RECALL SAVE

  • Displays serial numbers of all permanent SAVEs, date entered, and number of lines.

RECALL TEMP

  • Displays serial numbers of all temporary SAVEs, date entered, and number of lines.

RECALL SDI

  • Displays serial numbers of all SDIs, dates entered, databases in which stored, and number of lines.

Command: Execute

EXECUTING SEARCH*SAVES

EXECUTE nnnnn

  • Executes entire strategy. Only last line is assigned a EX nnnnn set number.

EXECUTE STEPS nnnnn

  • Executes entire strategy. Assigns set number to each EXS nnnnn search element. Preferred form.

EXECUTE nnnnn/x-y

  • Executes strategy nnnnn form command line x to command line y only. STEPS may also be used: EXS nnnnn/x-y

EXECUTE nnnnn/USER a

  • Executes strategy nnnnn originally entered by user a (a=user number).
  • STEPS may also be used
    Example: EXS nnnnn/USER a

EXECUTE nnnnn/x-y/USER a

 

  • Executes strategy nnnnn from command line x to command line y, originally entered by user a.
  • STEPS may also be used
    Example: EXS nnnnn/x-y/USER a

Deleting Search*Saves

RELEASE nnnnn

  • Deletes search nnnnn from system.
OTHER SEARCH*SAVE OPTIONS

NAMING

  • A three to five alphanumerical name may be specified following the SAVE, SAVE TEMP, and SAVE SDI commands.

  • Example: SAVE TEMP SOLAR

Adding Comments to a Search *Save

  • An informative comment may be stored in a SEARCH*SAVE by entering an asterisk in place of a command, followed by up to 240 characters of "comment."
  • The line will be saved with any SEARCH*SAVE command, and will display in RECALL of the search.
  • Example: * Search for R.J.Flappjack