DEFINEFILE

From CometWiki

Revision as of 12:45, 5 June 2009 by Badge (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

DEFINEFILE

Syntax: DEFINEFILE dictionary-file-name Placement: Place the DEFINEFILE command before the REPORT command. It can be useful when your PRINTER command directs your report's output to a data file and you wish to report on the data in that file. This command was introduced in version 8.00. Discussion: DEFINEFILE defines the file and all of its fields in your #CFILES dictionary. For example:


ERASE wrkfile,tmp MARGIN 0,79 PRINTER wrkfile,tmp DEFINEFILE my.work.file INPUT customer LINES 0 NOHEADINGS SPACES 0 INDENT 0 REPORT USING cust.to.hist PRINT cust.number;cust.name;ar.activity;previous.ytd

When this report is run, a new file called wrkfile will be created in the TMP folder. It will contain all the records generated by the report. A new entry in the #CFILES Data Dictionary will be generated which describes that file. Its Reporter name will be my.work.file. The field names will be the same as the ones in the original files.