Archives of the TeradataForum
Message Posted: Tue, 23 May 2006 @ 11:25:42 GMT
| Subj: | | Re: Regarding some issues in teradata |
| |
| From: | | Victor Sokovin |
| | 1) In Oracle has a dummy table namely DUAL which has only one column. Is there any Object like that in Teradata? | |
No, there is no equivalent. However, if you just want to select constants you can omit the FROM clause in Teradata:
select 1 from dual;
becomes
select 1;
| | 2) In Oracle we can EDIT any query by giving statement ED. Like that is there any option in teradata to EDIT in the BTEQ
mode? | |
In Bteq, you can execute OS commands. To call an external editor try
.os vi file_name;
or
.os edit file_name;
I am not aware of the option of editing an anonymous buffer like in SQL*Plus.
| | 3) In Oracle we got CL SCR to clear the screen. Let me know the which command is available in Bteq utility in Teradata? | |
I am only aware of this option in the Windows version of Bteq. Menu "Edit", followed by "Clear All". Perhaps with some trick it is possible to
do this via the .os command line but it is probably more difficult than just .os cls; or .os clear;.
Regards,
Victor
| 
