TABLE Syntax Summary

In this section:

The syntax of a TABLE request is:

DEFINE FILE filename    CLEAR|ADD 
tempfield  [/format]    [WITH realfield]
  [TITLE 'line1[,line2 ...']
  [DESCRIPTION 'description'] = expression; 
tempfield  [/format]    REDEFINES qualifier.fieldname = expression;
.
.
.
END
TABLE  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...obj1024]
      [WITHIN field]   [IN n]
COMPUTE field  [/format] = expression; [AS 'title,...,title5']  [IN n]
[AND]  ROW-TOTAL      [/R|/L|/C]    [/format][AS 'name']
[AND]  COLUMN-TOTAL   [/R|/L|/C]    [AS 'name']
ACROSS  [HIGHEST]  sortfieldn       [IN-GROUPS-OF qty]
    [NOPRINT|  AS 'title1,...,title5']
BY  [HIGHEST]  sortfieldn           [IN-GROUPS-OF qty]
    [NOPRINT|  AS 'title1,...,title5']
BY  [HIGHEST|LOWEST{n}]  TOTAL  [prefix_operator]  {field|code_value}
RANKED [AS 'name'] BY {TOP|HIGHEST|LOWEST} [n] field 
       [PLUS OTHERS AS 'othertext'] 
      [IN-GROUPS-OF qty [TILES [TOP m]] [AS 'heading']]
      [NOPRINT|AS 'title1,...,title5']
{BY|ACROSS} sortfield IN-RANGES-OF value [TOP limit]
ON   sfld  option1  [AND]  option2   [WHEN expression;...]
ON   sfld  RECAP   fld1  [/fmt] = FORECAST (fld2, intvl, npredct,
  '{MOVAVE|EXPAVE}',npnt);
ON sfld RECAP fld1[/fmt] = FORECAST(fld2, interval, npredict, 'DOUBLEXP', 
   npoint1, npoint2);
ON sfld RECAP fld1[/fmt] = FORECAST(fld2, interval, npredict, 'SEASONAL',  
   nperiod, npoint1, npoint2, npoint3);
ON   sfld  RECAP   fld1  [/fmt] = FORECAST (fld2, intvl, npredct, 
'REGRESS');
ON {sortfield|TABLE} RECAP y[/fmt] = REGRESS(n, x1, [x2, [x3,]] z);
ON   sfld  RECAP   fld1  [/fmt] = FORECAST (infield, interval, npredict,
  'DOUBLEXP',npoint, npoint2);
ON  sfld   RECAP   fld1  [/fmt] = FORECAST (infield, interval, npredict,
  'SEASONAL', nperiod, npoint, npoint2, npoint3);{BY|ON} fieldname 
SUBHEAD
  [NEWPAGE]
"text"
{BY|ON} fieldname SUBFOOT [WITHIN] [MULTILINES][NEWPAGE]
"text" [<prefop.fieldname ... ]"        [WHEN expression;]
WHERE   [TOTAL]  expression 
WHERE   {RECORDLIMIT|READLIMIT}  EQ  n 
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|SAVE|SAVB} [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE  NOTOTAL
ON TABLE  COLUMN-TOTAL [/R|/L|/C]  [AS 'name']  fieldname 
ON TABLE  {ROW-TOTAL|ACROSS-TOTAL}[/R|/L|/C][format] [AS 'name'] fldname 
{BY|ON}  sfld [AS 'text1']   {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [MULTILINES] [pref. ] [field1 [pref. ] field2 ...] [AS 'text2']
  [WHEN expression;]
{ACROSS|ON}  sfld [AS 'text1'] {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
   [AS 'text2']  [COLUMNS c1 [AND c2 ...]]
ON  TABLE {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [pref. ] [field1 [pref. ] field2 ...] [AS 'text2']
FOOTING  [CENTER]  [BOTTOM]
"text"
MORE
FILE  file2 
   [IF field relation value [OR value...]|WHERE expression]
{END|RUN|QUIT}

Top of page

x
Hierarchical Reporting Syntax Summary
SUM [FROLL.]measure_field ...
BY hierarchy_field [HIERARCHY [WHEN expression_using_hierarchy_fields;]
  [SHOW [TOP|UP n] [TO {BOTTOM|DOWN m}] [byoption [WHEN condition] ...] ]
[WHERE expression_using_dimension_data]
[ON hierarchy_field HIERARCHY [WHEN expression_using_hierarchy_fields;]
  [SHOW [TOP|UP n] [TO BOTTOM|DOWN m] [byoption [WHEN condition] ...]]

WebFOCUS