export to file_name
ʃrec_name(record_name | alpha_exp)ʅ
ʃrec_type(record_name | alpha_exp)ʅ
ʃcase_id (ʃitem_list]ʅ)ʅ
record_item_list; The export statement writes a record to an export file. Export statements can only be coded in
level procedures.
The rec_name, rec_type, and case_id phrases can each be coded only once, but can be coded in any order. They all must be coded before record_item_list. The order in which rec_type and case_id are coded determines the order of output of the record type and case ids in the exported record.
The
rec_name phrase is optional and is only needed when data are exported to CSPro format. When used, the
label and
name from the record name in the input dictionary is used for the label and name of the record type created in the exported dictionary. If an
alpha_exp is coded, then the label of the record type in the exported data dictionary is the result of the alphanumeric expression and the name is derived from the label. If rec_name is not coded, the labels and record names in the newly-created dictionary will be RECORD001, RECORD002, etc.
The rec_type phrase is optional. When coded it places a record type on the exported data record. If a record_name is coded, then the record type value from the record name in the input data dictionary is placed on the exported data file. If an alpha_exp is coded, then the value of the expression is placed on the exported data file.
The
case_id phrase is optional. When coded it is used to place
case identifiers on the exported data record. If case_id() is coded then ALL the case ids from the level in which the export statement is coded are placed on the exported data record. If no case_id phrase is coded and export format is CSPro, the ALL case ids from ALL levels will be output.
The record_item_list specifies the contents of the exported data record. This can be any combination of record names or item names.
Where possible users are encouraged to use the
Export Data tool instead of the export statement.