Suppose we have the following command present in Oracle and we need to have the same results when we run it in Teradata.
SELECT * FROM emp WHERE rownum <=3;
In BTEQ we have a SET command to limit the number of rows of output returned to the terminal/file. It is “set retlimit <number>”. This command has to be used with the “set retcancel” to stop query processing when the limit is reached. Create a Volatile table and insert a few rows as mentioned in this post. Logon to BTEQ session and type in the following commands one after another.
.set retlimit 3
.set retcancel on
SELECT * FROM emp ORDER BY emp_id;
ORDER BY clause mentioned in the above query is optional. Following results would be displayed on the terminal. *** Query completed. 10 rows found. 3 columns returned.
*** Total elapsed time was 1 second. emp_id startdate name
———– ——— ——————————
1 07/10/17 Bill
2 07/10/17 Dan
3 07/10/17 Harry
*** Warning: RetLimit exceeded.
Cancelling the request.
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.