TABLEF Syntax Summary

The syntax of a TABLEF request is:

TABLEF FILE filename 
HEADING [CENTER]
"text"
 
{display_command}  [SEG.]field  [/R|/L|/C]  [/format] 
{display_command}  [prefixop.][field] [/R|/L|/C] [/format]
    [NOPRINT|AS 'title1,...,title5']    [AND|OVER]    [obj2...obj495]
    [IN n]
COMPUTE field [/format]=expression; [AS 'title1,...title5']
[AND] ROW-TOTAL [AND] COLUMN-TOTAL
BY [HIGHEST] keyfieldn [NOPRINT]
ON keyfield option1 [AND] option2...
WHERE [TOTAL] expression
IF [TOTAL] field relation value [OR value...]
ON TABLE SET parameter value
ON TABLE HOLD [VIA program] [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE PCHOLD             [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE SAVE               [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE SAVB               [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE  NOTOTAL
ON TABLE  COLUMN-TOTAL fieldname 
ON TABLE  ROW-TOTAL fieldname
 FOOTING [CENTER] [BOTTOM]
 "text"
 
{END|RUN|QUIT}

Note: Prefix operators for TABLEF can be: AVE., ASQ., MAX., MIN., PCT., RPCT., PCT.CNT., FST., LST., CNT., SUM., or TOT. TABLEF requests cannot use prefix operators PCT.CNT., RPCT., and TOT.


WebFOCUS