EXPORTEJECT - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Enables control over suppression of the additional Page Advance ASA Carriage Control Character at the top of a REPORT format export file 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;