Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to extract longer than 254 bytes data records, using BTEQ (batch)

Status
Not open for further replies.

cici

MIS
May 28, 2001
2
AU
The script I am using works up to 254 bytes only.

.LOGON TERADATA/MYUID,MYPASSWD
DATABASE PRODDATA;
.EXPORT DATA FILE = c:\DATA\WEEKLY.DAT
.SET RECORDMODE OFF
.SET WIDTH 254
EXEC MACRO_TO_EXTRACT_CUSTOMER_DETAILS();
.EXPORT RESET
.QUIT
 
The latest version of BTEQ has a feature call REPORTWIDE as part of the Export command that will allow records wider than 254. I believe it is release 7.03.01
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top