Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 02 Apr 2001 @ 21:39:31 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Column Headers with Fast Export
 
From:   David Wellman

Whether this will work or not really depends on your existing output format.

Ahead of your 'real' select, you need a select statement that will write out a single row of literals which are your column headings. The trick is then to allow your client system to recognise and handle both row formats in the same file. If your real select contains binary data (i.e. integers, decimals etc) then this is very hard. You could cast those to CHAr fields, but that increases the size of your output file.

Also, what client system are you writing to - MVS, Unix?

If you're doing this on MVS, then you'll probably have to write a RECFM=VB file. Unix should simply handle the different record lengths and formats.

You'll also have to ensure that whatever program is going to read this file in knows that the first record is different.


Cheers,

Dave



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023