|
|
Archives of the TeradataForum
Message Posted: Mon, 28 Dec 2009 @ 10:18:19 GMT
Subj: | | Re: File truncation issue with BTEQ data export |
|
From: | | Chandana Oak |
Mohommod.Khan wrote:
| It is difficult to provide a solution without knowing what script you are running and what platform and how you are running etc. | |
| As you are saying below about chopping off the record, ensure you set a Width statement some thing like this: | |
Hi,
I am using BTEQ on Windows platform.
Also, even if I set the width to 3000 (even though the max record length is not more than 1000), I am facing this issue.
This is the script that I am running -
.export Report file = <>
.set titledashes off
.set heading ''
.set width 3000
.set format off
/* TAB DELIMITED. CHANGE TO DIFFERENT DELIMITER AS DESIRED */
.set separator '|'
SELECT
TRIM(FIRST_NM),
TRIM(LAST_NM),
TRIM(COUNTRY)
FROM <>
<>;
.export reset
The estimated no. of records to be exported are 80,000.
Thanks,
Chandana
|
| |
|
|
|
|
| |
| |
|
|
Copyright 2016 - All Rights Reserved |
Last Modified: 15 Jun 2023 |
|
|