Column Headings

Database
Enthusiast

Column Headings

In oracle at sql prompt we write set head off and set pages 0 to make the output with out column headings. what is its equivalent in TERADATA. Can anyone know this ? plz help.
2 REPLIES
Enthusiast

Re: Column Headings

Hi Monika,

use (title '') after the column name to make the output without column headings.

eg: sel date (title '');

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

08/03/01
Enthusiast

Re: Column Headings

thnx mahesh.
I am writing a shell script which will return a value from database. but i am not able to do so. plz help