Macro Example | Define the ddname of the Export File | Basic Teradata Query - 17.00 - Defining the ddname of the Export File - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

After creating the macro, use the appropriate syntax to define the ddname of the export file as follows:

Operating System Export File Syntax
z/OS
//EXPORT EXEC TDSBTEQ,
// L='logon string'
//REPORT DD DSN=your.report.dataname,DISP=(,KEEP),
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=6160),
// SPACE=(TRK,(5,5))
//SYSIN DD DISP=SHR,DSN=your.BTEQ.input
On z/OS, if the TSO command is used to define the ddname of the export file in the input stream file, it is not necessary to define the ddname in the CLIST. The input stream might include a command similar to the following example:
.TSO ALLOCATE DDNAME(repfile) DSNAME(your.report.dataname) SHR

An ALLOCATE statement must be used for TSO.