EXPORTEJECT Command | Basic Teradata Query - EXPORTEJECT (EEJ) - Basic Teradata Query

Basic Teradata® Query Reference - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
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



Shorthand Syntax (Interactive Mode Only)
Command Shorthand
EXPORTEJECT EEJ

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

The DEFAULTS command resets EXPORTEJECT setting to ON.

The EXPORTEJECT command is valid in an SQL macro.

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;