What is a Macro in Teradata and how is it used with respect to TIBCO Adapter (TM) for Teradata?
Article ID: KB0094397
Updated On:
| Products | Versions |
|---|---|
| TIBCO Adapter for Teradata | - |
| Not Applicable | - |
Description
Resolution:
A macro consists of one or more SQL statements that can be executed by performing a single statement. Each time the macro is performed, one or more rows of data can be returned. In other words, a macro defines a set of SQL statements that are frequently used or that performs a complex operation. The statements in the macro body are submitted when the macro is invoked by a subsequent EXECUTE statement.
In the adapter subscription, when the "Use Macros" field is selected, the adapter will create macros in the database for insert/update/delete/upsert operations, which will improve the performance.
A macro consists of one or more SQL statements that can be executed by performing a single statement. Each time the macro is performed, one or more rows of data can be returned. In other words, a macro defines a set of SQL statements that are frequently used or that performs a complex operation. The statements in the macro body are submitted when the macro is invoked by a subsequent EXECUTE statement.
In the adapter subscription, when the "Use Macros" field is selected, the adapter will create macros in the database for insert/update/delete/upsert operations, which will improve the performance.
Issue/Introduction
What is a Macro in Teradata and how is it used with respect to TIBCO Adapter (TM) for Teradata?
Feedback
Yes
No
Powered by
