Voici la syntaxe d'une requête TABLEF :
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] expressionIF [TOTAL] field relation value [OR value...]
ON TABLE SET parameter valueON 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}Remarque : les opérateurs de préfixe pour TABLEF peuvent s'agir de : AVE., ASQ., MAX., MIN., PCT., RPCT., PCT.CNT., FST., LST., CNT., SUM., ou TOT. Les requêtes TABLEF ne peuvent pas utiliser les opérateurs préfixes PCT.CNT., RPCT. et TOT.
| WebFOCUS |