EXPORTEJECT - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

EXPORTEJECT

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  

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  

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;