Archives of the TeradataForum

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

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

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>>