Querying the Database - Code-1_Plus - 5.0

CODE-1 Plus Guide for IBM i

Product type
Software
Portfolio
Verify
Product family
Data Quality - Postals
Product
CODE-1 Plus
Version
5.0
Language
English
Product name
CODE-1 Plus
Title
CODE-1 Plus Guide for IBM i
Copyright
2024
First publish date
1998
ft:lastEdition
2024-05-15
ft:lastPublication
2024-05-15T00:03:43.588945

The following steps clarify the concepts presented above.

  1. Start at the first database inquiry screen.

  2. Enter FLIP in the Command field and press Enter.

  3. Enter L LANHAM in the Command field. The screen changes to display only database inquiry without address matching.

  4. Enter SC 2 in the Command field and press Enter.

    Note: i You could also enter just SC. The line number defaults to 1, if no line number is entered in the Command field.

    The cursor moves to the Streets in a City screen for the city on the first line of the display (in this case, Lanham MD).

  5. Enter DOWN in the Command field and press Enter or press F8 to see the next display of streets in Lanham, MD. The screen appears with all the streets in Lanham, Maryland.

Note: iTo combine a display command and a locate command, you can enter the display command, followed by the line number for the display command, followed by the locate string. For example, if your screen displayed the cities in the database, positioned with LANHAM, MD as line 4, and you wanted to see all of the streets in LANHAM starting with PARLIAMENT PL, you would enter SC 4 PARLIAMENT. The Streets in a City screen would be displayed, and PARLIAMENT PL would be the second street displayed.