All Forums Tools
Suhas Joshi 5 posts Joined 08/06
04 Aug 2006
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.

ispaleny 8 posts Joined 12/04
07 Aug 2006

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

trying_to_learn 14 posts Joined 08/06
07 Aug 2006

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;


Suhas Joshi 5 posts Joined 08/06
08 Aug 2006

Thanks Ivo; That really helped;
-Suhas

You must sign in to leave a comment.