Displaying Available Fields

How to:

The ?F command displays the fields that are currently available.

?F displays entire 66 character field names.

Syntax: How to Display Available Fields

?F filename

where:

filename

Is the name of a data source.

Example: Displaying Available Fields

Issuing the command

?F EMPLOYEE

produces the following information:

FILENAME =  EMPLOYEE
EMP_INFO    EMP_ID      LAST_NAME      FIRST_NAME     HIRE_DATE
DEPARTMENT  CURR_SAL    CURR_JOBCODE   ED_HRS
BANK_NAME   BANK_CODE   BANK_ACCT      EFFECT_DATE
DAT_INC     PCT_INC     SALARY         PAYINFO        JOBCODE
TYPE        ADDRESS_LN1ADDRESS_LN2     ADDRESS_LN3    ACCTNUMBER
PAY_DATE    GROSS
DED_CODE    DED_AMT
JOBSEG      JOBCODE     JOB_DESC
SEC_CLEAR
SKILLS      SKILLS_DESC
DATE_ATTEND ATTENDSEG.EMP_ID
COURSE_CODE COURSE_NAME

Information Builders