Why do we need a macro? If there is a set of frequently used SQL statement which are being repeatedly executed, this set of SQL statement can be packed inside block and can be defined as a MACRO. A macro can include also execute another macro.
To create a macro to select today’s date:
CREATE MACRO today_date as (SELECT date;);
To execute a macro: EXEC today_date;To drop a macro:DROP macro today_date;A macro can also be used to insert row into tables with more than one input. Here is an example of a macro with multiple inputs which inserts a row to an emp table. Make sure that the table already exists.CREATE MACRO insert_into_emp
(
emp_no INTEGER,
dept_no VARCHAR(12),
first_name CHAR (20),
last_name”CHAR (20),
salary” INTEGER
)
AS
(
INSERT INTO emp
(emp_no, dept_no, first_name, last_name, salary)
values (:emp_no, :dept_no, :first_name, :last_name, :salary)
);
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.