Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 21:34:44 GMT

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

hello,

i am running queries that may return a 100,000 or so rows using BTEQ batch, but i want only the first heading to print and no more (the file will ultimately be uploaded to EXCEL). i know about the .SET PAGELENGTH command, but the max i can specifiy on my platform is 32767. after i return 32767 rows, i get another heading with this. does anyone know of another way to limit the print of the heading to only the first one ?

thanks

-scott t.

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