BTEQ Equivalent to SQL+ "EDIT" Command

Database
Teradata Employee

BTEQ Equivalent to SQL+ "EDIT" Command

Hi,

In BTEQ, is there any equivalent to Oracle's SQLPLUS "EDIT" command?

Oftently, it's hard to manipulate a multi-line query using the traditional BTEQ interface. Is there any workaround available?

-Wasif

Tags (1)
4 REPLIES
Enthusiast

Re: BTEQ Equivalent to SQL+ "EDIT" Command

If you are in a windows environment then why dont you try text editors like notepad++ or ultraedit...

Teradata Employee

Re: BTEQ Equivalent to SQL+ "EDIT" Command

That's what I have been doing so far. Positively, for interactive & ad-hoc query sessions, this doesn't seem to be an appropriate choice using BTEQ.

If I recall (in SQL+), if a huge query is executed and a little change is desired afterwards, all we need to do is to type "ED" and the same query automatically opens in a text editor for a possible modification. No need to explicitly create & maintain a separate script file.

In my case using BTEQ, I would have to:

>> Write [& Modify] the script

>> Save & maintain the file

>> Execute the script [from file]

An alternate option is to use an ODBC client (SQLA, DDI), but they don't support sub/aggregate totalling functionality. 

Enthusiast

Re: BTEQ Equivalent to SQL+ "EDIT" Command

True but I think thats the limitation we have to live with while using BTEQ

Highlighted
Teradata Employee

Re: BTEQ Equivalent to SQL+ "EDIT" Command

@Qaisar, Anyhow, thanks for looking into this.