.run file=filename path (i.e. c:\mypath\mysubpath\myfirstBTEQ.txt;
To set/change default database for the session;
Database <database name>;
To display all the default BTEQ settings
show control;
To show object (table, view etc) definition or create object statement
show <table/view/index/procedure/trigger> ;
To terminate the connection as well as BTEQ session
.quit/.exit;
To terminate the connection only and NOT the BTEQ session
.logoff
To see columns in a table or view
help [table/view] <database.table/view name>;
To list all the objects present in a particular database,
help database <database name>
To display column headings vertically
.set sidetitles on
Remember that all BTEQ commands (NOT SQL commands you run in BTEQ) must be preceded by a dot ‘.’ character and also BTEQ commands may or may not end with a semicolon ‘;’. If you want to execute BTEQ commands inside of a DBC/SQL query/macro, this can be done by using the ECHO statement, for example:
echo ‘.help bteq’;
The ‘help bteq’ command displays a complete list of BTEQ commands with syntax.
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links
4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.