Is there an equivalent of glogin.sql in Teradata

Tools
Enthusiast

Is there an equivalent of glogin.sql in Teradata

I am using an application that generates a sql query and executes this query on a database specified by the user; Whenever the sql is executed on Teradata (using bteq), the output columns are truncated;
Although the options ".set foldline on",".set sidetitles on" will help, the application I use is database independent and will not set these paramters when executing on Teradata.

Like in Oracle, where we can set the session parameters like dateformat linesize etc in glogin.sql, is there a way to set the session parameters on Teradata that will be used for all logins to the database.

3 REPLIES
Enthusiast

Re: Is there an equivalent of glogin.sql in Teradata

Hi,

You can do it for BTEQ by running:

MODIFY USER my_user AS STARTUP = 'echo ''set foldline on;'';echo ''set sidetitles on;'';'

I guess "Default" user is a master copy of every new user.

So you must modify all existing users and "Default" user.

Good luck,

Ivo Spaleny
Enthusiast

Re: Is there an equivalent of glogin.sql in Teradata

In addition to Ivo Spaleny help, type in the following in your BTEQ script and try... Good luck.. :-)

.echoreq on;
.pagelength 5000;
.null '~';
.set width 254;
.set retlimit 10;
.set retcancel on;

Enthusiast

Re: Is there an equivalent of glogin.sql in Teradata

Thanks Ivo; That really helped;
-Suhas