Archives of the TeradataForum
Message Posted: Mon, 02 Apr 2001 @ 21:39:31 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|