How to execute a Teradata Macro in a DS job?

varaprasad · Post by **varaprasad** » Wed Sep 10, 2008 1:23 am

Hi,
I want to execute a Teradata parameterized macro in a DataStage job.
The job will have one input sequential file stage from where I will get some values and using them as parameters I have to execute a macro in the target Teradata stage.
How to achieve this?

ray.wurlod · Post by **ray.wurlod** » Wed Sep 10, 2008 1:39 am

How do you execute Teradata macros in SQL (or in BTEQ)? You use exactly the same techniques - embedding them in SQL statements typically - if using them from DataStage.

varaprasad · Post by **varaprasad** » Wed Sep 10, 2008 3:18 am

Thank you Ray. Infact, I am facing difficulty while passing the parameters. For eg, I can execute the following macro in Teradata as follows:
exec macro_name(param);
In my DataStage job, I will be getting that parameter from a seq file
as a value.
How to deal with this? Plz help.

toshea · Post by **toshea** » Wed Sep 10, 2008 11:20 am

Have you tried using the Teradata API stage using the User-defined SQL option? Put your EXECUTE statement in the User-defined SQL.

nishadkapadia · Post by **nishadkapadia** » Wed Sep 10, 2008 11:53 am

What specific problem you are facing, since if using Teradata API stage and the normal method of mentioning 'USING <<column_name>> , followed by exec <<macro_name>> ( :column_name ).

Do please post any specific message / error you are facing.

varaprasad · Post by **varaprasad** » Thu Sep 11, 2008 4:13 am

nishadkapadia wrote:What specific problem you are facing, since if using Teradata API stage and the normal method of mentioning 'USING <<column_name>> , followed by exec <<macro_name>> ( :column_name ).

Do please post any specific message / error you are facing.

It was my mistake, It got resolved when I mentioned the datatype in the u/d sql. Thanks Nishad.