Entering FSCAN

In this section:

Enter the full-screen FSCAN facility from FOCUS with 

FSCAN FILE filename

where:

filename

Is the name of the database you are editing. The database must be a FOCUS database. You may also enter FSCAN by typing: 

FS FILE filename

For example, to edit the EMPLOYEE database, enter:

FSCAN FILE EMPLOYEE

Entering FSCAN With a SHOW List

How to:

By default, FSCAN makes all fields in the database available to the user. However, it is possible to restrict the fields available with the SHOW option.

Syntax: How to Enter FSCAN With a SHOW List 

FSCAN FILE filename SHOW
[fieldname......fieldname....|SEG.fieldname]
END

where:

SHOW

Indicates that specific fields will be displayed. The SHOW keyword must appear on the same line as the FSCAN command.

fieldname...

Are the fields to be displayed.

END

Is required and must be specified on a line by itself.

Example: Entering FSCAN With a SHOW List

For example, the commands

FSCAN FILE EMPLOYEE SHOW
EMP_ID LAST_NAME FIRST_NAME SEG.GROSS
END

would provide access to only the selected fields in the root segment and to the whole segment containing the field GROSS. The above commands would produce the following display: 

FSCAN   FILE   EMPLOYEEFOCUS   A                CHANGES :0
         EMP_ID       LAST_NAME    FIRST_NAME
------   ---------    ---------    ----------
==       071382660    STEVENS      ALFRED
==       112847612    SMITH        MARY
==       117593129    JONES        DIANE
==       119265415    SMITH        RICHARD
==       119329144    BANNING      JOHN
==       123764317    IRVING       JOAN
==       126724188    ROMANS       ANTHONY
==       219984371    MCCOY        JOHN
==       326179357    BLACKWOOD    ROSEMARIE
==       451123478    MCKNIGHT     ROGER
==       543729165    GREEENSPAN   MARY
----------------------------INPUT--------------------------------------
==
==>
 
                                                              MORE=>

The only child segment that can be displayed is the SALINFO segment, which contains the field GROSS.

Allowing Uppercase and Lowercase Alpha Fields

How to:

By default, FSCAN translates all input and changed alpha fields to uppercase. If uppercase and lowercase input and updates are to be respected, then enter FSCAN with the LOWER keyword.

Syntax: How to Specify Case Sensitivity in FSCAN 

FSCAN FILE filename [case]

where:

case

Is one of the following:

UPPER translates all input and changed alpha fields into uppercase. UPPER is the default.

LOWER preserves uppercase and lowercase input and is analogous to the CRTFORM LOWER statement in MODIFY.

MIXED is a synonym for LOWER.

Information Builders