EXPORTEJECT

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

Purpose

This control enables users to specify whether the additional Page Advance ASA Carriage control character at the top of a REPORT format export file is to be suppressed when using z/OS BTEQ.

This command is not valid on Workstation-attached systems. The command works only for disposition type DISP=(OLD,NEW,SHR) on z/OS.

Syntax



Usage Notes

When EJECT or NOEJECT has been specified as part of an EXPORT command, that option overrides the current EXPORTEJECT setting for the duration of the export.

Command Usage Results
The EXPORTEJECT command is not specified. The default value is ON.
The EXPORTEJECT command is specified, the ON or OFF options are not specified. BTEQ sets EXPORTEJECT to ON

Example 1 – EXPORTEJECT

Using the following example results in the suppression of the additional page advance in the exported file when the EXPORTEJECT setting is OFF at the script level and neither the EJECT nor NOEJECT keyword is used with the EXPORT command:

.SET EXPORTEJECT OFF;
.EXPORT REPORT DDNAME=MYDD;
SELECT date;
.EXPORT RESET;

Example 2 – EXPORTEJECT

Using the following example results in the generation of an additional page advance in the exported file because the EXPORT command's “EJECT” keyword overrides the value of the EXPORTEJECT command:

.SET EXPORTEJECT ON;
.EXPORT REPORT EJECT DDNAME=MYDD;
SELECT date;
.EXPORT RESET;