If your report request contains syntax errors, FOCUS will generate an error message that provides a general description of the error and/or an error message number. For example, in the request below the fieldname should be AC:WNAME.
ERROR AT OR NEAR LINE 6 IN PROCEDURE EMPHIST FOCEXEC
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: AC:NAME
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
>
Note: FOCUS error message number 009 (FOC009) is received anytime the system cannot process the report request due to the previous error(s) identified.
If the information provided by the error message is not sufficient, type a ? and the number of the error message at the prompt and press ENTER for a detailed explanation.
> ? 003
(FOC003) THE FIELDNAME IS NOT RECOGNIZED
A word which is assumed to be the name of a data field does not appear on the list of names or aliases for the file. Check the spelling of the fieldname.
> >
To edit your report request, type EX MAINT at the prompt and press enter. When prompted, type the name of the request (program) and press the enter key twice.
> >ex maint
PLEASE SUPPLY VALUES REQUESTED
PROGRAM= > emplist
You will be placed in your report request under edit mode. Changes can be made using all the edit functions available when your report request is accessed from the main menu. For more information, refer to the topic: Edit Report Requests.
After making changes to your program, press F3 to save the changes and return to the online FOCUS environment.
EDIT PD.CSUCFOC.userid(EMPLIST) Line 00000000 Col 001 008
Command ==> Scroll ===> PAGE
****** ******************** Top of Data **************************
000100 -* EMPLOYEE LIST - RUN QUARTERLY
000200 EX JACPS
000300 TABLE FILE AC
000400 HEADING CENTER
000500 "CURRENT EMPLOYEE LIST"
000600 PRINT AC:WNAME AS 'EMPLOYEE'
000700 AC:CLASS AS 'CLASS'
000800 PS:TITLEA AS 'TITLE'
000900 AC:FTE AS 'FTE'
001000 BY AC:AGYUNIT AS 'AREA'
001100 BY AC:WNAME NOPRINT
001200 IF RECORDLIMIT EQ 10 '
001300 FOOTING
001400 "DATA AS OF <AC:DAO"
001500 END
****** ******************Bottom of Data***************************
You can execute the report again by typing the command EX at the prompt followed by the name of the program. If a report is generated, it will display in the hot screen.
> >ex emplis
Last Updated: April 11, 2024