Stream
Use this command to retrieve all data for the given DataArea. This command should be used in place of the DOWNLOAD command when working with very large amounts of data. A DataArea is created using the Create DataArea command, and initially consists of an empty Structure only. The Stream command is then used in conjunction with the Run (for ExportSpecs) command to populate the DataArea with data from the database. For more information, see Run (for ExportSpecs).
Note: The STREAM command can be used for ODS exports only.
The STREAM command opens a stream for the data. When the Stream command is used in conjunction with the Run (for ExportSpecs) command, the data is downloaded and exported one block at a time. In comparison, the Download (for DataAreas) command downloads all data and builds the data tree before export.
Note: When the STREAM command is used, no data is saved in the created DataArea. This command will download only DataAreas to which the user has access.
Syntax
STREAM DataAreaName [StandardAll|StandardLeafOnly|CTA|LeafData|Validation]
where:
- DataAreaName is the name of the DataArea created by the command.
- StandardAll specifies that all standard data will be downloaded. This option is the default for the DOWNLOAD command.
- StandardLeafOnly specifies that only standard leaf data will be downloaded.
- CTA specifies that only CTA data will be downloaded.
- LeafData specifies that only true leaf data will be downloaded. This option differs from StandardLeafOnly in that it does not include calculated data on leaf symbols.
- Validation specifies that the discrepancy calculated by a validation rule is downloaded. You must use the Rule function to specify the server rule associated with this calculation.
Syntax example
STREAM DataArea1 StandardLeafOnly
See also