Teradata Macros

[DS1]

Hello everyone,

I am suppose to calll a teradata macro in DS job and pass parameters to it ...
Is the teradata macro the same as the stored procedure ?
How does macro differ from a teradata bteq script.

Thanks for reading

DS1

[jharvat]

Teradata macros and stored procedures are two different animals. They can do similar functions but you can do more programming logic in a stored procedure and you can also do DDL statements and execute dynamic SQL from a stored procedure. A quick check of the TD manuals should give you a better idea of the capabilities and shortcomings of both.

A BTEQ script, meanwhile, can contain one or more SQL statements and contain some basic error checking and branching logic. It is designed specifically to be run by the BTEQ utility. Macros and stored procedures are more portable in that they can be executed anywhere you can execute an SQL statement (SQL Assistant or equivalent software, etc.).

You should be able to execute a macro just like any custom SQL from a BTEQ Enterprise stage. Unfortunately, that is the extent of my knowledge. I would also like to know how you can pass dynamic parameters to a macro in DataStage. Can someone else fill in the blanks?

Thanks!

---

Hello everyone,

I am suppose to calll a teradata macro in DS job and pass parameters to it ...
Is the teradata macro the same as the stored procedure ?
How does macro differ from a teradata bteq script.

Thanks for reading

DS1

[ray.wurlod]

I would also like to know how you can pass dynamic parameters to a macro in DataStage. Can someone else fill in the blanks?

See separate thread in server forum.