Archives of the TeradataForum
Message Posted: Fri, 12 Nov 2004 @ 14:03:37 GMT
| Subj: | | Re: New to BTEQ |
| |
| From: | | Dieter Noeth |
Harshida Patel wrote:
| | - I am to create an export file in data mode, but it adds the leading hex for lrecl. How do I get rid of those? | |
Bteq will always add that word, you'll have to use a Unix tool to strip it from the output file. Or use FastExport instead.
| | - If I use report mode to export the data it creates titles and the additional ---- line. How to suppress these | |
There are two ways to get rid of the header:
- you add a (TITLE '') to each column in your select list
- you specify "EXPORT DATA" instead of "EXPORT FILE" and add a "SET RECORDMODE OFF" before the select. This switches back to Report
format and omits the header, but is undocumented behaviour.
| | - Would the report mode support more than million records? | |
Yes, but a FastExport might be more efficient.
Dieter
| 
