EXPORTEJECT Command | Basic Teradata Query - EXPORTEJECT - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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;