DSXchange

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 ...

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.

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?

Can we do this in a single call (shell command) without creating any scripts?