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_LN1 ADDRESS_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